This documentation is archived and is not being maintained.

Shapes Members 

A collection of all the Shape objects on the specified sheet. Each Shape object represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture.

The following tables list the members exposed by the Shapes type.

  Name Description
Application Returns an Application object that represents the Microsoft Excel application.
Count Returns the number of objects in the collection.
Creator Returns a 32-bit integer that indicates the application in which this object was created.
Parent Returns the parent object for the specified object.
Range Returns a ShapeRange object that represents a subset of the shapes in a Shapes collection.
Top

  Name Description
_Default  
AddCallout Creates a borderless line callout. Returns a Shape object that represents the new callout.
AddCanvas  
AddConnector Creates a connector. Returns a Shape object that represents the new connector.
AddCurve Returns a Shape object that represents a Bézier curve in a worksheet.
AddDiagram Creates a diagram. Returns a Shape object that represents the new diagram.
AddFormControl Creates a Microsoft Excel control. Returns a Shape object that represents the new control.
AddLabel Creates a label. Returns a Shape object that represents the new label.
AddLine Returns a Shape object that represents the new line in a worksheet.
AddOLEObject Creates an OLE object. Returns a Shape object that represents the new OLE object.
AddPicture Creates a picture from an existing file. Returns a Shape object that represents the new picture.
AddPolyline Creates an open polyline or a closed polygon drawing. Returns a Shape object that represents the new polyline or polygon.
AddShape Returns a Shape object that represents the new AutoShape in a worksheet.
AddTextbox Creates a text box. Returns a Shape object that represents the new text box.
AddTextEffect Creates a WordArt object. Returns a Shape object that represents the new WordArt object.
BuildFreeform Builds a freeform object. Returns a FreeformBuilder object that represents the freeform as it is being built.
GetEnumerator Returns an enumerator to support iterating through the collection.
Item Returns a single object from a collection.
SelectAll Selects all the shapes in the specified Shapes collection.
Top
Show: