EVENTS -- On this page, we will be discussing only Excel's events related to Sheets, Workbooks, and the Application, which are completely independent of the events for user forms and controls on user forms.The setting, discussed later, has no effect on events of user forms or controls on user forms.I’ve posted several examples of manipulating pivot tables with VBA, for example, Dynamic Chart using Pivot Table and VBA and Update Regular Chart when Pivot Table Updates.
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.
The declaration will tell you what the parameters for the event are, but you will still need to use Help to obtain a description of the meaning and usage of the parameters.
Event procedures must be declared exactly as they are defined.
You must not alter the name or parameter list of an event procedure. The events are "hard coded" into the object, such as a Worksheet, and may not be changed.