Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 15. Adding Interactive Controls ... > Using the Check Box Control
15.3. Using the Check Box Control
The check box control provides a mechanism for selecting/deselecting options. When a check box is selected, it returns a value of True. When it isn't selected, False is returned. To add and configure a check box control, follow these steps:
Select the Insert drop-down list under the Developer tab.
Select the check box Form control.
Click the location in your spreadsheet where you want to place your check box.
After you drop the check box control onto your spreadsheet, right-click the control and select Format Control.
Click the Control tab to see the configuration options, as shown in Figure 15-6.
Select the state in which the check box should open.
The default selection (Unchecked) typically works for most scenarios, so it's rare you have to update this selection.
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 15-6 that this particular check box outputs to cell A5.
(Optional) You can check the 3D property if you want the control to have a 3-D appearance.
Click OK to apply your changes.
