EVALTEXT function
Evaluates the text in shapename as if it were a formula and returns the result.
Syntax
|
EVALTEXT(shapename!theText) | |
|
shapename!theText |
A cell that is triggered when the associated shape's text composition changes. Shapename! can be used to refer to the text of a shape other than the current shape. |
Remarks
If there is no text, the result is zero. If the text cannot be evaluated, the function returns an error.
Example
EVALTEXT(Line.2!theText)
Evaluates the text contained in the shape Line.2. For example, if Line.2 contains "4 ft + 0.5 ft", returns the value 4.5 ft.