Syntax

expression.AddLabel(Orientation, Left, Top, Width, Height)

expression A variable that represents a Shapes object.

Parameters

Name Required/Optional Data Type Description
Orientation Required The text orientation within the label.
Left Required Single The position (in points) of the upper-left corner of the label relative to the upper-left corner of the document.
Top Required Single The position (in points) of the upper-left corner of the label relative to the top corner of the document.
Width Required Single The width of the label, in points.
Height Required Single The height of the label, in points.

Return Value
Shape

Example

This example adds a vertical label that contains the text "Test Label" to myDocument.

Visual Basic for Applications
Set myDocument = Worksheets(1) myDocument.Shapes.AddLabel(msoTextOrientationVertical, _ 100, 100, 60, 150) _ .TextFrame.Characters.Text = "Test Label"
add label Add Label Method Add label object? AddLabel addlabel method

See also: