Learn Excel VBA Events Completely with 5 Tutorials

If you work with Excel VBA, you must work with different types of events. Event is like a situation. For example:

  1. You change the value of a cell in a worksheet; it is an event.
  2. Or you open a new worksheet in a workbook; it is also an event.
  3. You close a workbook; it is an event.
  4. You delete a worksheet from a workbook; it is an event.
  5. So there might be so many events when you work with Excel.

It is not necessary that when an event occurs, something will happen automatically. You have to control/handle the events. For example:

Event PartHandling Part
You change the value of a cell in a worksheetAnother cell will change its background color depending on the value of the first cell.
You open a new worksheet in a workbookThe new worksheet’s some cells will be filled with some predetermined values.
You close a workbookIt will show some message to the user of the workbook.
You delete a worksheet from a workbookIt will show some message to the user of the workbook.

In this post, I have linked back to my old 5 tutorials that will teach you Excel VBA Events completely and in step by step procedure:

  1. What are Excel Events and Their Types.
  2. How to Enter Event Handler VBA Code.
  3. Workbook-level Events and Their Uses.
  4. Worksheet-related Events and Their Uses.
  5. How to Use Non-object Events.

If you follow the above tutorials step by step, you will be able to make any complicated project using Excel VBA Events. Just you have to do a little practice.

Happy Excelling 🙂


Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

1 Comment

      Leave a reply