TextFrame Object - Microsoft Office Excel

Remarks

Use the TextFrame property to return a TextFrame object.

Example

The following example adds a rectangle to myDocument, adds text to the rectangle, and then sets the margins for the text frame.

Visual Basic for Applications

Visual Basic for Applications
`Set myDocument = Worksheets(1) With myDocument.Shapes.AddShape(msoShapeRectangle, _ 0, 0, 250, 140).TextFrame .Characters.Text = "Here is some test text" .MarginBottom = 10 .MarginLeft = 10 .MarginRight = 10 .MarginTop = 10 End With`

Set myDocument = Worksheets(1) With myDocument.Shapes.AddShape(msoShapeRectangle, _ 0, 0, 250, 140).TextFrame .Characters.Text = "Here is some test text" .MarginBottom = 10 .MarginLeft = 10 .MarginRight = 10 .MarginTop = 10 End With

Text Frame Object textframe TextFrame Object What is represented by textframe?

See also: