TheText Cell (Events Section)
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

TheText Cell (Events Section)

Office 2010

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:


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

Section index:


Row index:


Cell index:


© 2015 Microsoft