TheText cell (Events section)

Microsoft Office ShapeSheet

TheText cell (Events section)

       Rows

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

Remarks

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 reference the TheText cell by name from another formula, or from a program using the Cells property, use:

Cell name:

TheText

To reference 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