Check boxes are one of the easiest controls to use. They allow you to turn off and turn on calculations and features at the click of the mouse. They are also easy to create and implement. This session includes a couple of worked examples.
This session covers
- display the Developer tab to allow inserting check boxes
- tips on creating check boxes
- easily link to a cell
- a special format to hide entries
- incorporating the check box in formulas
- validating check boxes
- using range names with check boxes
- protecting sheets
- a macro to create multiple check boxes in one step
There are tips and keyboards shortcuts along the way.
Level: Intermediate
Duration: 1 hour
Price: AU$25