TEXTHEIGHT function

Microsoft Office ShapeSheet

TEXTHEIGHT function

Returns the height of the composed text in a shape where no text line exceeds maximumwidth.

Syntax

TEXTHEIGHT(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 returned value includes the height of the text including the space before and after text, the line spacing in text, and the top and bottom text block margins. This function is commonly used to adjust the height of a shape to fit the text it contains.

Example

TEXTHEIGHT(TheText,(Width - 0.5 in.))

Returns the height of the text when wrapped to the width of the shape minus 0.5 inches.