Events and Event Procedures were introduced in Excel97. Events and event procedures are the same for versions 97 through 2007.
No significant changes have been made to the event model since its introduction in Excel97.
This event is raised automatically by Excel when a cell's value is changed either by user input or by other VBA code.
It is not raised if the value of the cell is changed by a formula calculation in that cell.
All the events for the selected item in the left dropdown will be listed in the right dropdown.
If you see an item of interest, let go of the mouse button and the VBA editor will insert that event's procedure declaration in the code module.
A few new events have been added, but the overall structure of the event system is unchanged.
The setting, discussed later, has no effect on events of user forms or controls on user forms.There is no direct way to determine whether the cause of the event was user input or VBA code.You should write your events procedures such that this distinction does not matter.On this page, we will cover Application events in only in general terms, but not in much detail since they require a different coding model.(See Application Events for a discussion of Application events.) An event is said to be when the action that initiates the event occurs and the application automatically sends a signal to all components connected to event-generating object (e.g, a Worksheet) indicating that the event has occured.