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 ...
Get VBA Automation for Excel 2019 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
