Shapes Members

Include Protected Members
Include Inherited Members

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

The Shapes type exposes the following members.

Properties

	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

Methods

	Name	Description
	_Default	Reserved for internal use.
	AddCallout	Creates a borderless line callout. Returns a Shape object that represents the new callout.
	AddCanvas	Reserved for internal use.
	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.
	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.
	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.
	GetEnumerator()	(Inherited from IEnumerable.)
	GetEnumerator()
	Item	Returns a single object from a collection.
	SelectAll	Selects all the shapes in the specified Shapes collection.

Top

See Also

Reference

Shapes Interface

Microsoft.Office.Interop.Excel Namespace