Chapter 17. Automating Procedures with Excel Events

Understanding Excel Events

An event occurs in Excel whenever the user performs any type of action. For example, an event occurs when the user closes a workbook. You can use events to trigger the execution of procedures by creating event procedures. Event procedures are exactly what the name describes: procedures that execute when a particular event occurs.

To trap or capture an event with an event procedure, you must place the procedure code in the correct type of module. For example, workbook-related events must be in the ThisWorkbook object standard module.

There are several categories of events. Each event category has a set of events associated with it. For example, the BeforeClose event is ...

Get Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.