title | manager | ms.date | ms.audience | ms.topic | f1_keywords | ms.localizationpriority | ms.assetid | description | |
---|---|---|---|---|---|---|---|---|---|
TEXTHEIGHT Function |
lindalu |
03/09/2022 |
Developer |
reference |
|
medium |
5a10892f-c8fa-c127-2f5a-564009ce5411 |
Returns the height of the composed text in a shape where no text line exceeds maximumwidth. |
Returns the height of the composed text in a shape where no text line exceeds maximumwidth.
TEXTHEIGHT(shapename!TheText [,maximumwidth])
Name | Required/Optional | Data Type | Description |
---|---|---|---|
shapename!theText |
Required |
String |
A reference to the cell named TheText in the target shape. shapename! is the name of the shape from which you want to retrieve the text. |
maximumwidth |
Optional |
Numeric |
The maximum width of the text block. |
String
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.
TEXTHEIGHT(TheText,(Width - 0.5 in))
Returns the height of the text when wrapped to the width of the shape minus 0.5 inches.