Introduction to Events in Excel VBA

By

Power Spreadsheets

The main purpose of Introduction to Events in Excel VBA is to help you:

• Work with events; and
• Create procedures that are executed automatically: (i) When an event occurs; and (ii) Without having to take additional action.

As you learn in Introduction to Events in Excel VBA:

• The (main) reason events are important in VBA is the fact that VBA allows you to monitor (certain) events. Once such an event occurs, VBA recognizes this.
• You can use this information to automatically execute a procedure upon a specific (monitored) event occurring.

Introduction to Events in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
  
• Assumes you know about the topics covered in: (i) My previous Book Series, particularly the Excel Macros for Beginners Book Series; and (ii) The previous Books in the VBA Fundamentals Book Series, particularly Procedure Calling in Excel VBA and Variables, Data Types and User-Defined Constants in Excel VBA.
  

Introduction to Events in Excel VBA is divided into four Chapters.

• Chapter 1 is an introduction to events in VBA.
• In Chapter 2, you learn: (i) What event handler procedures are; and (ii) How to create and store event handler procedures.
• In Chapter 3, you learn: (i) What event sequences are; and (ii) How to enable or disable event monitoring.
• Chapter 4 contains examples to help you practice working with: (i) Events; and (ii) Event handler procedures.