Shapes.AddTextbox (Excel)

Creates a text box. Returns a Shape object that represents the new text box.

AddTextbox (Orientation, Left, Top, Width, Height)


Dim shpAddTextbox As Shape
Set shpAddTextbox = ActiveChart.Shapes.AddTextbox(Orientation:=msoTextOrientationMixed, Left:=, Top:=, Width:=, Height:=)

Arguments

The following arguments are required:

Orientation (Office.MsoTextOrientation) - The orientation of the textbox.

Left (Single) - The position (in points) of the upper-left corner of the text box relative to the upper-left corner of the document.

Top (Single) - The position (in points) of the upper-left corner of the text box relative to the top of the document.

Width (Single) - The width of the text box, in points.

Height (Single) - The height of the text box, in points.