TextFrame2 Properties (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Properties

Name

Description

Application

Returns an Application object. Read-only.

AutoSize

The size of the specified object that changes automatically to fit text within its boundaries. Read/write MsoAutoSize.

Column

Returns the TextColumn2 object that represents the columns within the text frame. Read-only.

Creator

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

HasText

Returns whether the specified text frame has text. Read-only MsoTriState.

HorizontalAnchor

Returns or sets the horizontal anchor type for the specified text. Read/write MsoHorizontalAnchor.

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.

NoTextRotation

Returns or sets whether text remains flat when the specified object is rotated. Read/write

Orientation

Returns or sets a value that represents the text frame orientation. Read/write MsoTextOrientation.

Parent

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

PathFormat

Returns or sets the path type for the specified text frame. Read/write MsoPathFormat.

Ruler

Returns a Ruler2 object that represents the ruler for the specified text. Read-only.

TextRange

Returns the TextRange2 object that represents the text in the object. Read-only.

ThreeD

Returns a ThreeDFormat object that contains 3-D–effect formatting properties for the specified text. Read-only.

VerticalAnchor

Returns or sets the vertical anchor type for the specified text. Read/write MsoVerticalAnchor.

WarpFormat

Returns or sets the warp type for the specified text frame. Read/write MsoWarpFormat.

WordArtformat

Returns or sets the Word Art type for the specified text frame. Read/write MsoPresetTextEffect.

WordWrap

Returns or sets text break lines within or past the boundaries of the shape. Read/write MsoTriState.