Change Event

                  Applies To

Occurs whenever data in one or more cells changes. Both edits and copy-and paste-operations cause this event to occur.

Syntax

Private Sub Spreadsheet_Change(SpreadsheetEventInfo As SpreadsheetEventInfo)

SpreadsheetEventInfo   The SpreadsheetEventInfo object that contains information about the event.

Remarks

This event occurs after the EndEdit event; at this point, the data has already been changed and the change cannot be canceled.