Share via


TextFrame.AutoSize Property

Excel Developer Reference

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.

Visual Basic for Applications
  Worksheets(1).Shapes(1).TextFrame.AutoSize = True

See Also