GroupObjects Collection Object

Description

A collection of all the GroupObject objects on the specified chart sheet, dialog sheet, or worksheet. Each GroupObject represents a group of graphic objects and controls. Unlike other collection objects, the GroupObjects object has no Add method. Groups are created and added to the collection using either the Group method or the Group Objects button on the Drawing toolbar.

Do not confuse GroupObject objects, which combine objects into a single logical collection but do not affect dialog sheet behavior, with GroupBox objects, which group option buttons on a dialog sheet.

Accessors

Use the GroupObjects 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 ungroups all of the graphic object groups on the worksheet named "Sheet1."


Worksheets("sheet1").GroupObjects.Ungroup

Properties

AddIndent Property, Application Property, ArrowHeadLength Property, ArrowHeadStyle Property, ArrowHeadWidth Property, AutoSize Property, Border Property, Count Property, Creator Property, Enabled Property, Font Property, Height Property, HorizontalAlignment Property, Interior Property, Left Property, Locked Property, OnAction Property, Orientation Property, Parent Property, Placement Property, PrintObject Property, RoundedCorners Property, Shadow Property, Top Property, VerticalAlignment Property, Visible Property, Width Property, ZOrder Property.

Methods

BringToFront Method, CheckSpelling Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Group Method, Item Method, Select Method, SendToBack Method, Ungroup Method.