Shapes.AddShape method (Excel)
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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.