Many times we want to do some predefined and repetitive steps before the workbook closes. For example, closing connections to the database, deleti...
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...
Throughout your VBA practices, you would get the need to run macros when a certain range or cell changes. In that case, to run macros when a change is...
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.
