How to Run a Macro Automatically Before Workbook Close in Excel

Many times we want to do some predefined and repetitive steps before the workbook closes. For example, closing connections to the database, deleti...

How to Run a Macro Automatically When Workbook Opens in Excel

Many times we want to run some predefined and repetitive steps as the workbook opens or closes. For example, opening up a connection to the databa...

How to Create Application Level Events in Excel VBA

The Application level events work on the entire application(Excel in this reference). But activating the application event is not as easy as creating ...

The Events in Excel VBA

In General, the events are nothing but are happening of something. It is the same in excel. But sometimes we want something to happen automatically wh...

Simplest VBA Code to Highlight Current Row and Column

If you want to highlight the row and column of the active cell, the below VBA code will help you. So, we will be using the Excel Worksheet Event Ha...

The Worksheet Events in Excel VBA

You may want to run your macro/VBA snippet when a cell changes its value, when a double click happens, when a sheet is selected, etc. In all these cas...

Using Worksheet Change Event To Run Macro When any Change is Made

If you are here, its probably you want to learn how to run a subroutine every time a change is made in a specific sheet. This article will teach exact...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube