Description
Represents a check box control on a chart sheet, dialog sheet, or worksheet. You can set the position and size of a check box. On a worksheet or chart, you can also format the border and background of the check box. The font is fixed.
Accessors
The CheckBox object is a member of the CheckBoxes collection. The CheckBoxes collection contains all the CheckBox objects on a single sheet. Use the Add method to create a new check box and add it to the collection.
To access a single member of the collection, use the CheckBoxes method with the index number or name of the check box as an argument.
The following example links check box one on dialog sheet one to cell A1 on the worksheet named "Sheet1." When the value of cell A1 is TRUE, the check box is turned on, and vice versa.
DialogSheets("sheet1").CheckBoxes(1).LinkedCell = "=sheet1!a1"
The check box name is shown in the Name Box when the check box is selected. Use the Name property to set or return the check box name. The following example turns on the check box named "Check Box 5."
DialogSheets(1).CheckBoxes("check box 5").Value = True
Properties
Accelerator Property, Application Property, Border Property, BottomRightCell Property, Caption Property, Creator Property, Display3DShading Property, Enabled Property, Height Property, Index Property, Interior Property, Left Property, LinkedCell Property, Locked Property, LockedText Property, Name Property, OnAction Property, Parent Property, PhoneticAccelerator Property, Placement Property, PrintObject Property, Text Property, Top Property, TopLeftCell Property, Value Property, Visible Property, Width Property, ZOrder Property.
Methods
BringToFront Method, Characters Method, CheckSpelling Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Select Method, SendToBack Method.