Programming Excel with VBA and .NET

Name

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

Synopsis

Draws an autoshape and returns the autoshape’s Shape object.

Argument	Settings
Type	An msoAutoShapeType constant. Can be any of the settings listed following this table.
Left	The horizontal position of the shape in points.
Top	The vertical position of the shape in points.
Width	The width of the shape in points.
Height	The height of the shape in points.

The msoAutoShapeType constant can be one of:

msoShape4pointStar msoShape5pointStar msoShape8pointStar msoShape16pointStar msoShape24pointStar msoShape32pointStar msoShapeActionButtonBackorPrevious msoShapeActionButtonBeginning msoShapeActionButtonCustom msoShapeActionButtonDocument msoShapeActionButtonEnd msoShapeActionButtonForwardorNext msoShapeActionButtonHelp msoShapeActionButtonHome msoShapeActionButtonInformation msoShapeActionButtonMovie msoShapeActionButtonReturn msoShapeActionButtonSound msoShapeArc msoShapeBalloon msoShapeBentArrow msoShapeBentUpArrow msoShapeBevel msoShapeBlockArc msoShapeCan msoShapeChevron msoShapeCircularArrow msoShapeCloudCallout msoShapeCross msoShapeCube msoShapeCurvedDownArrow msoShapeCurvedDownRibbon msoShapeCurvedLeftArrow msoShapeCurvedRightArrow msoShapeCurvedUpArrow msoShapeCurvedUpRibbon msoShapeDiamond msoShapeDonut msoShapeDoubleBrace msoShapeDoubleBracket msoShapeDoubleWave msoShapeDownArrow msoShapeDownArrowCallout msoShapeDownRibbon msoShapeExplosion1 msoShapeExplosion2 msoShapeFlowchartAlternateProcess msoShapeFlowchartCard ...