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.

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

i 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 check mark. If False, it does not have a check mark.

Figure 17-4:

The Help system provides lots of information for each property and control.

Table of Contents

^Methods ^Objects Properties

¡g) Accelerator Property ig) ActiveControl Property (g) Alignment Property @ AutoSize Property ¡jfj) AutoTab Property (g) AutoWordSelect Property i^] BackColor Property @ Backs tyle Property (g)Bold, Italic, Size, StrikeThroui (g) BorderColor Property ¡g) BorderStyle Property (jgjl BoundColumn Property (g) BoundValue Property (^Cancel Property ¡fyi CanPaste Property (g) CanRedo Property (g) CanUndo Property (g) Caption Property (§) ClientHelght, ClientLeft, Clier (¡¿j) Column Property @ ColumnCount Property (g) ColumnHeads Property ColumnWidths Property iaft ControlSource Property

ControlSource pf^perty object. ControlSource [= String] The ControlSource property syntax has these parts: Part Description abject Required. A valid object.

Optional. Specifies the worksheet cell linked to the Value property of a control,



The ControlSource property identifies a cell or Field; it does not contain the data stored in the cell or field, If you change the Value of the control, the change is automatically reflected in the linked cell or field. Similarly, if you change the value of the linked cell or field, the change is automatically reflected in the Value of the control,

Vou cannot specify another control for the ControlSource, Doing so causes an

The default value for ControlSource is an empty string. If ControlSource contains a value other than an empty string, it identifies a linked cell or field. The contents of that cell or field are automatically copied to the Value property when the control is loaded.

Developer Reference


Figure 17-5:

CheckBox controls.

Figure 17-5:

CheckBox controls.

0 0

Post a comment