Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
True if the size of the specified object is changed automatically to fit text within its boundaries. Read/write Boolean.
Syntax
expression.AutoSize
expression A variable that represents a TextFrame object.
Example
This example adjusts the size of the text frame on shape one to fit its text.
Worksheets(1).Shapes(1).TextFrame.AutoSize = True
Support and feedback
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.