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.

Visual Basic for Applications 
Worksheets(1).Shapes(1).TextFrame.AutoSize = True
Alter the size of the specified object to automatically fit the text within its boundary? AUTO SIZE AUTO SIZE PROPERTY Automatically change dimension of text frame to fit text? AutoSize autosize property Resize textframe to fit text?

See also: