Share via


TextFrame Members (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.

Methods

Name

Description

Characters

Returns a Characters object that represents a range of characters within a shape’s text frame. You can use the Characters object to add and format characters within the text frame.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

AutoMargins

Returns or sets whether Excel automatically calculates text frame margins. Read/write

AutoSize

True if the size of the specified object is changed automatically to fit text within its boundaries. Read/write Boolean.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

HorizontalAlignment

Returns or sets a XlHAlign value that represents the horizontal alignment for the specified object.

HorizontalOverflow

Returns or sets the horizontal overflow setting for the specified object. Read/write

MarginBottom

Returns or sets the distance (in points) between the bottom of the text frame and the bottom of the inscribed rectangle of the shape that contains the text. Read/write Single.

MarginLeft

Returns or sets the distance (in points) between the left edge of the text frame and the left edge of the inscribed rectangle of the shape that contains the text. Read/write Single.

MarginRight

Returns or sets the distance (in points) between the right edge of the text frame and the right edge of the inscribed rectangle of the shape that contains the text. Read/write Single.

MarginTop

Returns or sets the distance (in points) between the top of the text frame and the top of the inscribed rectangle of the shape that contains the text. Read/write Single.

Orientation

Returns or sets a Long value that represents the text frame orientation.

Parent

Returns the parent object for the specified object. Read-only.

ReadingOrder

Returns or sets the reading order for the specified object. Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long.

VerticalAlignment

Returns or sets a XlVAlign value that represents the vertical alignment of the specified object.

VerticalOverflow

Returns or sets the vertical overflow setting for the specified object. Read/write