CheckBox
Inserts a labeled checkbox control into the spreadsheet.
Note: To access the Property Sheet for a CheckBox,
right-click the CheckBox and select Edit
Function.
CheckBox Inputs
Parameter | Description |
Name |
Specifies a text string or reference to a test string; this will appear as a label next to the CheckBox. |
CheckBox Outputs
Returns |
A value of 0 when cleared (unchecked), and 1 when selected (checked.) |
Results |
A labeled CheckBox control. |
CheckBox Example
A spreadsheet is configured as follows:
A3=CheckBox("On")
A4=A3
Cell A4 references cell A3 to determine the on/off status of the "On" checkbox. When the checkbox is cleared, the value 0.000 will be returned in cell A4. When the checkbox is selected, the value 1.000 will be returned.