Share via

TextFrame Object Members

  • Article
Excel Developer Reference

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
Bb225727.methods(en-us,office.12).gif 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
Bb225727.properties(en-us,office.12).gif 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.
Bb225727.properties(en-us,office.12).gif AutoSize True if the size of the specified object is changed automatically to fit text within its boundaries. Read/write Boolean.
Bb225727.properties(en-us,office.12).gif HorizontalAlignment Returns or sets a XlHAlign value that represents the horizontal alignment for the specified object.
Bb225727.properties(en-us,office.12).gif 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.
Bb225727.properties(en-us,office.12).gif 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.
Bb225727.properties(en-us,office.12).gif 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.
Bb225727.properties(en-us,office.12).gif 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.
Bb225727.properties(en-us,office.12).gif Orientation Returns or sets a Long value that represents the text frame orientation.
Bb225727.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225727.properties(en-us,office.12).gif 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.
Bb225727.properties(en-us,office.12).gif VerticalAlignment Returns or sets a XlVAlign value that represents the vertical alignment of the specified object.