Expand Minimize
This topic has not yet been rated - Rate this topic

TheText Cell (Events Section)

Published: July 16, 2012

An event cell that is evaluated when a shape's text or text composition changes.

Event cells are evaluated only when the event occurs, not upon formula entry. You can use the TheText cell to trigger recalculations, for example, to recalculate the text width and height with the TEXTWIDTH( ) and TEXTHEIGHT( ) functions.

To get a reference to the TheText cell by name from another formula, or from a program using the CellsU property, use:

Cell name:

TheText

To get a reference to the TheText cell by index from a program, use the CellsSRC property with the following arguments:

Section index:

visSectionObject

Row index:

visRowEvent

Cell index:

visEvtCellTheText

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.