TextFrame Property
Collapse the table of content
Expand the table of content

Shape.TextFrame Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

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

Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. Read-only.

expression .TextFrame

expression A variable that represents a Shape object.

This example causes text in the text frame in shape one to be justified. If shape one doesn’t have a text frame, this example fails.

Worksheets(1).Shapes(1).TextFrame _ 
 .HorizontalAlignment = xlHAlignJustify

Concepts

Other resources

Show:
© 2016 Microsoft