Shapes.AddShape Method
Returns a Shape object that represents the new AutoShape in 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 upper-left corner 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've added, set the AutoShapeType property.
Example
This example adds a rectangle to myDocument.
| Visual Basic for Applications |
|---|
|