Shape.TextFrame property (Excel)
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
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.