Returns a Shape object that represents the new AutoShape on a worksheet.
Syntax
expression.AddShape (Type, Left, Top, Width, Height)
expression A variable that represents a Shapes object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Type | Required | MsoAutoShapeType | Specifies the type of AutoShape to create. |
| Left | Required | Single | The position (in points) of the upper-left corner of the AutoShape's bounding box relative to the upper-left corner of the document. |
| Top | Required | Single | The position (in points) of the upper-left corner of the AutoShape's bounding box relative to the top of the document. |
| Width | Required | Single | The width of the AutoShape's bounding box, in points. |
| Height | Required | Single | The height of the AutoShape's bounding box, in points. |
Return value
Shape
Remarks
To change the type of an AutoShape that you have added, set the AutoShapeType property.
Example
This example adds a rectangle to myDocument.
Set myDocument = Worksheets(1)
myDocument.Shapes.AddShape msoShapeRectangle, 50, 50, 100, 200