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
Syntax: CheckBox(Name)
Parameter | Description |
---|---|
Specifies a text string label to appear 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 is returned in cell A4. When the checkbox is selected, the value 1.000 is returned.