Many times we want to do some predefined and repetitive steps before the workbook closes. For example, closing connections to the database, deleti...
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...
The Application level events work on the entire application(Excel in this reference). But activating the application event is not as easy as creating ...
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...
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...
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...
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...
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.