Shapes Members (Excel)

A collection of all the Shape objects on the specified sheet.

Methods

Name	Description
AddCallout	Creates a borderless line callout. Returns a Shape object that represents the new callout.
AddChart	Creates a chart at the specified location on the active sheet.
AddConnector	Creates a connector. Returns a Shape object that represents the new connector. When a connector is added, it's not connected to anything. Use the BeginConnect and EndConnect methods to attach the beginning and end of a connector to other shapes in the document.
AddCurve	Returns a Shape object that represents a Bézier curve in a worksheet.
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	As it applies to the Shapes object, 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.
AddSmartArt	Creates a new SmartArt graphic with the specified layout.
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. Use the AddNodes method to add segments to the freeform. After you have added at least one segment to the freeform, you can use the ConvertToShape method to convert the FreeformBuilder object into a Shape object that has the geometric description you’ve defined in the FreeformBuilder object.
Item	Returns a single object from a collection.
SelectAll	Selects all the shapes in the specified Shapes collection.

Properties

Name	Description
Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Count	Returns a Long value that represents the number of objects in the collection.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Parent	Returns the parent object for the specified object. Read-only.
Range	Returns a ShapeRange object that represents a subset of the shapes in a Shapes collection.