GroupShapes Collection Object [Excel 2003 VBA Language Reference]
Represents the individual shapes within a grouped shape. Each shape is represented by a Shape object. Using the Item method with this object, you can work with single shapes within a group without having to ungroup them.
Using The GroupShapes Collection
Use the GroupItems property to return the GroupShapes collection. Use GroupItems(index), where index is the number of the individual shape within the grouped shape, to return a single shape from the the GroupShapes collection. The following example adds three triangles to
myDocument, groups them, sets a color for the entire group, and then changes the color for the second triangle only.
Set myDocument = Worksheets(1) With myDocument.Shapes .AddShape(msoShapeIsoscelesTriangle, _ 10, 10, 100, 100).Name = "shpOne" .AddShape(msoShapeIsoscelesTriangle, _ 150, 10, 100, 100).Name = "shpTwo" .AddShape(msoShapeIsoscelesTriangle, _ 300, 10, 100, 100).Name = "shpThree" With .Range(Array("shpOne", "shpTwo", "shpThree")).Group .Fill.PresetTextured msoTextureBlueTissuePaper .GroupItems(2).Fill.PresetTextured msoTextureGreenMarble End With End With
Methods | Item Method
Child Objects | ShapeRange Object