Tags Activate event
Tag: activate event
An event is an action that can trigger the execution of the specified macro. For example, when you open a new workbook, it’s an event. When you insert a new worksheet, it’s an event. When you double-click on a cell, it’s an event. There are many such events in VBA, and you can create codes for these events. This means that as soon as an event occurs, and if you have specified a code for that event, that code would instantly be executed. Excel automatically does this as soon as it identifies that an event has taken place. So we only need to write the code and place it in the correct event subroutine.