TextFrame object (Excel)

Represents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame.

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.

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

Methods

Name
Characters

Properties

Name
Application
AutoMargins
AutoSize
Creator
HorizontalAlignment
HorizontalOverflow
MarginBottom
MarginLeft
MarginRight
MarginTop
Orientation
Parent
ReadingOrder
VerticalAlignment
VerticalOverflow

See also

Excel Object Model Reference