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