TextFrame Members (Excel)

Article
09/14/2015

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