Microsoft Office Tutorials and References
In Depth Information
Using the Button Control
3. Click the location in your spreadsheet where you want to place your check box.
4. After you drop the check box control onto your spreadsheet, right-click the control and
select Format Control.
5. Click the Control tab to see the configuration options, as shown in Figure 12-6.
6. Select the state in which the check box should open.
The default selection (Unchecked) typically works for most scenarios, so you rarely have to
update this selection.
7. In the Cell Link box, enter the cell to which you want the check box to output its value.
By default, a check box control outputs either True or False, depending on whether it’s
checked. Notice in Figure 12-6 that this particular check box outputs to cell A5.
8. (Optional) You can check the 3-D property if you want the control to have a 3-D appearance.
9. Click OK to apply your changes.
Figure 12-6: Formatting the check box control.
To rename the check box control, right-click the control, select Edit Text, and then
overwrite the existing text with your own.
As Figure 12-7 illustrates, the check box outputs its value to the specified cell. If the check box is
selected, a value of True is output. If the check box isn’t selected, a value of False is output.
Figure 12-7: The two states of the check box.