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.
Public Properties
| Name | Description | |
|---|---|---|
.gif) |
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
Public Methods
| Name | Description | |
|---|---|---|
.gif) |
_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