EVALTEXT Function

Office 2013 and later

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

String

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.

Show: