You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Fired before a cell's contents is updated.

Parameters

ParameterDescription
CellCell whose text is about to be updated
TextUpdated contents of the cell
ValidationThe cell's validation pattern

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.

The Cell parameter indicates the cell whose text is about to be updated, and the Text property contains the new contents of the cell.

Using the Cancel property to cancel the event only works if the event was qualified synchronously.

See Also

AfterUpdateBeforeDeleteRecordsBeforeNewRecordsCellProtection

  • No labels