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

Shape.TextFrame Property (Excel)

Office 2013 and later

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


Other resources

© 2016 Microsoft