Edit

Shapes.AddShape method (Excel)

  • Article

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.