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
Name	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.