Class TextFrame2 (Excel VBA)

The class TextFrame2 represents the text frame in a Shape, ShapeRange, or ChartFormat object.

The classes ChartFormat and Shape. give access to class TextFrame2

Methods

DeleteText - Deletes the text from a text frame and all the associated text properties.

Properties

AutoSize the size of the specified object that changes automatically to fit text within its boundaries.

Column returns the TextColumn2 object that represents the columns within the text frame.

HasText returns whether the specified text frame has text.

HorizontalAnchor returns or sets the horizontal anchor type for the specified text.

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.

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.

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.

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.

NoTextRotation returns or sets whether text remains flat when the specified object is rotated.

Orientation returns or sets a value that represents the text frame orientation.

PathFormat returns or sets the path type for the specified text frame.

Ruler returns a Ruler2 object that represents the ruler for the specified text.

TextRange returns the TextRange2 object that represents the text in the object.

ThreeD returns a ThreeDFormat object that contains 3D-effect formatting properties for the specified text.

VerticalAnchor returns or sets the vertical anchor type for the specified text.

WarpFormat returns or sets the warp type for the specified text frame.

WordArtformat returns or sets the Word Art type for the specified text frame.

WordWrap returns or sets text break lines within or past the boundaries of the shape.

ThreeDFormat - Represents a shape's three-dimensional formatting.