Description
A collection of all the GroupBox objects on the specified chart sheet, dialog sheet, or worksheet. Each GroupBox object represents a static frame used to label and group sets of option buttons (OptionButton objects) and other controls. Group boxes control how option buttons select and clear. All option buttons with an upper-left corner contained within the group box boundaries are considered to be part of a group, and only one option button within that group can be turned on at any given time.
Do not confuse GroupBox objects, which group option buttons on a dialog sheet, with GroupObject objects, which combine objects into a single logical collection but do not affect dialog sheet behavior.
Accessors
Use the Add method to create a new group box and add it to the collection. The following example creates a new group box on dialog sheet one.
DialogSheets(1).GroupBoxes.Add 77, 44, 82, 63
Use the GroupBoxes 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 deletes all of the group boxes on the worksheet named "Sheet1."
Sheets("sheet1").GroupBoxes.Delete
Properties
Accelerator Property, Application Property, Caption Property, Count Property, Creator Property, Display3DShading Property, Enabled Property, Height Property, Left Property, Locked Property, LockedText Property, OnAction Property, Parent Property, PhoneticAccelerator Property, Placement Property, PrintObject Property, Text Property, Top 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.