Shapes.AddShape (Excel)

Returns a Shape object that represents the new AutoShape on a worksheet.

To change the type of an AutoShape that you have added, set the AutoShapeType property.

AddShape (Type, Left, Top, Width, Height)

Dim shpAddShape As Shape
Set shpAddShape = ActiveChart.Shapes.AddShape(Type:=msoShapeMixed, Left:=, Top:=, Width:=, Height:=)

Arguments

The following arguments are required:

Type (Office.MsoAutoShapeType) - Specifies the type of AutoShape to create.

Left (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 (Single) - The position (in points) of the upper-left corner of the AutoShape's bounding box relative to the top of the document.

Width (Single) - The width of the AutoShape's bounding box, in points.

Height (Single) - The height of the AutoShape's bounding box, in points.