Check Box control

A CheckBox control is useful for getting a binary choice: yes or no, true or false, on or off, and so on. Figure 17-5 shows some examples of CheckBox controls.

Figure 17-5:

CheckBox controls.

Figure 17-5:

CheckBox controls.

The following is a description of a CheckBox control's most useful properties:

1 Accelerator: A letter that lets the user change the value of the control by using the keyboard. For example, if the accelerator is A, pressing Alt+A changes the value of the CheckBox control (from checked to unchecked, or from unchecked to checked).

i ControlSource: The address of a worksheet cell that's linked to the CheckBox. The cell displays TRUE if the control is checked or FALSE if the control is not checked.

i Value: If True, the CheckBox has a checkmark. If False, it does not have a checkmark.

0 0

Post a comment