Share via


Shapes Object Members

Excel Developer Reference

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

Methods

  Name Description
Bb225671.methods(en-us,office.12).gif AddCallout Creates a borderless line callout. Returns a Shape object that represents the new callout.
Bb225671.methods(en-us,office.12).gif AddChart Creates a chart at the specified location on the active sheet.
Bb225671.methods(en-us,office.12).gif 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.
Bb225671.methods(en-us,office.12).gif AddCurve Returns a Shape object that represents a Bézier curve in a worksheet.
Bb225671.methods(en-us,office.12).gif AddFormControl Creates a Microsoft Excel control. Returns a Shape object that represents the new control.
Bb225671.methods(en-us,office.12).gif AddLabel Creates a label. Returns a Shape object that represents the new label.
Bb225671.methods(en-us,office.12).gif AddLine As it applies to the Shapes object, returns a Shape object that represents the new line in a worksheet.
Bb225671.methods(en-us,office.12).gif AddOLEObject Creates an OLE object. Returns a Shape object that represents the new OLE object.
Bb225671.methods(en-us,office.12).gif AddPicture Creates a picture from an existing file. Returns a Shape object that represents the new picture.
Bb225671.methods(en-us,office.12).gif AddPolyline Creates an open polyline or a closed polygon drawing. Returns a Shape object that represents the new polyline or polygon.
Bb225671.methods(en-us,office.12).gif AddShape Returns a Shape object that represents the new AutoShape in a worksheet.
Bb225671.methods(en-us,office.12).gif AddTextbox Creates a text box. Returns a Shape object that represents the new text box.
Bb225671.methods(en-us,office.12).gif AddTextEffect Creates a WordArt object. Returns a Shape object that represents the new WordArt object.
Bb225671.methods(en-us,office.12).gif 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.
Bb225671.methods(en-us,office.12).gif Item Returns a single object from a collection.
Bb225671.methods(en-us,office.12).gif SelectAll Selects all the shapes in the specified Shapes collection.

Properties

  Name Description
Bb225671.properties(en-us,office.12).gif 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.
Bb225671.properties(en-us,office.12).gif Count Returns a Long value that represents the number of objects in the collection.
Bb225671.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Bb225671.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225671.properties(en-us,office.12).gif Range Returns a ShapeRange object that represents a subset of the shapes in a Shapes collection.