TEXTWIDTH function

Microsoft Office ShapeSheet

TEXTWIDTH function

See also

Returns the width of the composed text in a shape.

Syntax

TEXTWIDTH(shapename!TheText,maximumwidth)

shapename!

A name that refers to the text of a shape other than the current shape. Default equals the current shape.

TheText

A cell that gets triggered when the associated shape's text composition changes.

maximumwidth

Optional. The maximum width of the text block.

Remarks

The TEXTWIDTH function is commonly used to adjust the width of a shape to fit the text it contains.

If maximumwidth is specified, the result is the longest line of text that fits within maximumwidth. If maximumwidth is omitted, the result is the total width of the text.

Example

TEXTWIDTH(TheText)

Returns the total length of the text in the current shape.