Writing event handler procedures

In this recipe, we will be working with a new type of procedure, known as event handler procedures. This is a special type of procedure, designed and placed in such a way that it will do nothing else but handle events.

Important note

For a list of every possible event available in VBA, follow this link: https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.tools.excel.workbook?redirectedfrom=MSDN&view=vsto-2017#events.

Getting ready

Open Excel and activate a new workbook. Save the file as a macro-enabled file on your desktop and call it Events. Sheet1 should be active. Press Alt + F11 to switch to the VBA Editor.

How to do it…

Let's create our first event handler procedure:

1. Instead of inserting a new module, double-click on the workbook object in Project Explorer:

   Figure 10.1 – Code window for ThisWorkbook

2. In the code window, click on the drop-down arrow on the left and choose the object that...