Chapter 10: Implementing Automation
Automation comes in different flavors. Simple recorded macros, for instance, can be used to eliminate the drudgery of repetitive tasks. Even keyboard shortcuts are a form of automation. However, when messages start popping up while you open or close a file or because you forget to make backups, the word automation takes on a new meaning. This chapter is all about those event-driven procedures, which is a major step toward automation in VBA. Therefore, the benefits of event procedures are increased production and better interaction with users.
In standard English, an event is something that happens – a wedding or a conference, for example. In VBA, an event is also something that happens, such as when you click on a button, or when you save, open, or close a file. You can also say that an event procedure is a sub-routine that runs automatically in response to an event in the workbook.