Discovering events
In the following section, we will be creating three different types of events. The principle behind any event will always be the same; in other words, something must happen in Excel to trigger the event procedure.
What has not been mentioned explicitly is that different objects in the Excel VBA environment will respond to different events. It makes sense that you can enter data in the cell of a worksheet, but not in a workbook. Similarly, you cannot save a cell, while a workbook can and must be saved.
The three event types to be discussed will explain this principle in detail, in the remaining recipes of this chapter.