i am a hombuilder and i have begun creating a workbook to streamline some paperwork operations. the workbook has three sheets (file attached). the sheet named 'options' has several checkboxes for different options.
i would like to create a formula that searchs for all checked options and inserts them in the 'start order' worksheet.
please take a look at the attached file and any help would be greatly appreciated.
upon second look i have a question: how does the 'start order' page update? ie. when different options are selected on the 'options' page, they do not update on the 'start order' page without clearing the worksheet first.
also, how can i change the formatting of the checkboxes?
You need to hit the Clear Options checkbox (it should actually be a Command Button) toward the bottom of the Options sheet. That was the most efficient way I could think of doing it on Friday with me in I wanna scoot mode.
As for formatting the CheckBoxes, they're ActiveX controls, so goto View-->Toolbars-->Control Toolbox. Enter Design Mode (the Speed Square looking thing), then View-->Properties. ActiveX controls are much easier to work with in regards to formatting than Forms controls.