Microsoft Office Tutorials and References
In Depth Information
Monitoring with Application Events
continued
Notice how the list is divided into three columns: Library, Class, and Member. The match for the
item that you’re searching for might appear in any of these columns. This brings up a crucial
point: The name of an event or term belonging to one library or class could be the same as that
for another belonging to a different library or class — although they probably don’t share the
same functionality. So be sure to click each item in the Object Browser list and check the status
bar at the bottom of the list for the syntax. You may find, for example, that one class or library
treats an event differently.
Refer to Chapter 18 for examples that deal with Chart events. Chapter 18 also
describes how to create a class module to enable events for embedded charts.
Table 19-3 contains a list of the chart events as well as a brief description of each.
Table 19-3: Events Recognized by a Chart Sheet
Event
Action That Triggers the Event
Activate
The chart sheet or embedded chart is activated.
BeforeDoubleClick
The chart sheet or an embedded chart is double-clicked. This event occurs
before the default double-click action.
BeforeRightClick
The chart sheet or an embedded chart is right-clicked. The event occurs before
the default right-click action.
Calculate
New or changed data is plotted on a chart.
Deactivate
The chart is deactivated.
MouseDown
A mouse button is pressed while the pointer is over a chart.
MouseMove
The position of the mouse pointer changes over a chart.
MouseUp
A mouse button is released while the pointer is over a chart.
Resize
The chart is resized.
Select
A chart element is selected.
SeriesChange
The value of a chart data point is changed.
Monitoring with Application Events
In earlier sections, I discuss Workbook events and Worksheet events. Those events are
monitored for a particular workbook. If you want to monitor events for all open workbooks or all
worksheets, you use Application -level events.
 
Search JabSto ::




Custom Search