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.
Inputs
| Parameter | Description |
|
Name |
Specifies a text string or reference to a test string; this will appear as a label next to the 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.