Page History
...
| Parameter | Description |
|---|---|
| Cell | Cell whose text is about to be updated |
| Text | Updated contents of the cell |
| Validation | The cell's validation pattern |
| Message | The cell's validation message |
| OldText | The cell's text before it went into edit mode |
Remarks
The BeforeUpdate event is fired when the user leaves a cell while in edit mode but before the changes to the cell's text has been applied. To prevent the cell's contents from being updated, set the Cancel property to 1. If the CellProtection property for the cell is anything other than "None," then this event never fires since the user can never edit the cell's contents.
...
