EVALTEXT Function
Evaluates the text in shapename as if it were a formula and returns the result.
Syntax
EVALTEXT(shapename!theText )
Parameters
Name | Required/Optional | Data Type | Description |
---|---|---|---|
shapename!theText |
Required |
String |
A cell that is triggered when the associated shape's text composition changes. |
Return value
String
Remarks
shapename can be used to refer to the text of a shape other than the current shape.
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.