This documentation is archived and is not being maintained.
EVALTEXT Function
Last modified: March 09, 2015
Applies to: Office 2013 | Visio 2013
In this article
Syntax
Remarks
Example
Evaluates the text in shapename as if it were a formula and returns the result.
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
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.
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.