Description
A collection of all the CheckBox objects on the specified 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
Use the Add method to create a new check box and add it to the collection. The following example adds a new check box to the dialog sheet named "Dialog1." The new check box is positioned inside the dialog frame.
Dim df as DialogFrame
DialogSheets("dialog1").Activate
Set df = ActiveSheet.DialogFrame
ActiveSheet.CheckBoxes.Add df.Left + 10, df.Top + 10, 100, 10
Use the CheckBoxes method with an argument to access a single member of the collection or without an argument to access the entire collection at once. The following example turns off (clears) all of the check boxes on the dialog sheet named "Dialog1."
DialogSheets("dialog1").CheckBoxes.Value = xlOff
Properties
Accelerator Property, Application Property, Border Property, Caption Property, Count Property, Creator Property, Display3DShading Property, Enabled Property, Height Property, Interior Property, Left Property, LinkedCell Property, Locked Property, LockedText Property, OnAction Property, Parent Property, PhoneticAccelerator Property, Placement Property, PrintObject Property, Text Property, Top Property, Value Property, Visible Property, Width Property, ZOrder Property.
Methods
Add Method (Graphic Objects and Controls), BringToFront Method, Characters Method, CheckSpelling Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Group Method, Item Method, Select Method, SendToBack Method.