EVALTEXT function

See also

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.