Page 281 - Excel Data Analysis

15 537547 AppC.qxd 3/4/03 11:56 AM Page 267

VBA AND EXCEL EVENTS QUICK REFERENCE C

EXCEL EVENTS QUICK REFERENCE (CONTINUED)

Application Events (Continued)
EVENT TYPE DESCRIPTION
SheetFollowHyperlink A user clicks a hyperlink on a sheet.
SheetPivotTableUpdate Excel updates a sheet of a PivotTable report.
SheetSelectionChange The selection changes on any worksheet.
WindowActivate Excel activates a worksheet window.
WindowDeactivate Excel deactivates a worksheet window.
WindowResize The user resizes a worksheet window.
WorkbookActivate The user activates a workbook.
WorkbookAddInInstall An add-in installs a workbook.
WorkbookAddInUninstall An add-in uninstalls a workbook.
WorkbookBeforePrint Excel prints an open workbook.
WorkbookBeforeSave Excel saves an open workbook.
WorkbookDeactivate Excel deactivates a workbook.
WorkbookNewSheet Excel adds a new sheet to an open workbook.
WorkbookOpen Excel opens a workbook.
WorkbookPivotTableCloseConnection Occurs after a PivotTable report closes the data source connection.
WorkbookPivotTableOpenConnection Occurs after a PivotTable report opens the data source connection.
Chart Events
EVENT DESCRIPTION
Activate Excel activates the chart sheet.
BeforeDoubleClick Occurs before the user double-clicks the chart sheet with the mouse.
BeforeRightClick Occurs before the user clicks the chart sheet with the right
mouse button.
Calculate Occurs after Excel plots the chart.
Deactivate Excel deactivates the chart sheet.
DragOver The user drags a range of cells over a chart.
DragPlot The user drags and drops a range of cells onto the chart.
MouseDown The user presses a mouse button over the chart.
MouseMove The position of a mouse changes over a chart.
MouseUp The user releases a mouse over the chart.
Resize The user resizes the chart.
Select The user selects a chart element.
SeriesChange Occurs when the user changes the value of a chart data point.

267