Shape, ShapeRange, and Shapes Members

Use the Shapes collection to draw graphics on a worksheet or chart. Use the Worksheet or Chart object’s Shapes property to get a reference to this collection. Use the Shape object to change the appearance of one shape; use ShapeRange to change groups of shapes. Shapes, Shape and ShapeRange have the following members. Key members (shown in bold) are covered in the following reference section:

Diagramming the Shape object hierarchy

Figure 18-12. Diagramming the Shape object hierarchy

1 Collection only

2 Object and collection

3 ShapeRange only

AddCallout 1

AddConnector 1

AddCurve 1

AddDiagram 2

AddFormControl 1

AddLabel 1

AddLine 1

AddOLEObject 1

AddPicture 1

AddPolyline 1

AddShape 1

AddTextbox 1

AddTextEffect 1

Adjustments

Align 3

AlternativeText

Application 2

Apply

AutoShapeType

BlackWhiteMode

BottomRightCell

BuildFreeform 1

Callout

Child

ConnectionSiteCount

Connector

ConnectorFormat

ControlFormat

Copy

CopyPicture

Count 1

Creator 2

Cut

Delete

Diagram

DiagramNode

Distribute 3

Duplicate

Fill

Flip

FormControlType

Group 3

GroupItems

HasDiagram

HasDiagramNode

Height

HorizontalFlip ...

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial