Any time a value in a cell is changed, this macro will be run. The variable Target will tell you
which cell and the new value of the cell. Surprisingly, using this method does not significantly
slow down the process.

Note that the macro will stay active as long as the worksheet is open or until you run a macro
with the following line in it:

Application.EnableEvents = False

In Excel 95/7.0: You need to use the OnEntry method. You specify a macro that you want
to be run after any value is entered. In this case, the variable Application.Caller
contains the address and value that changed. Enter the following in a new module:

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.MrExcel.com debuted on November 21, 1998.

All contents Copyright 1998-2017 by MrExcel Consulting.
This page last updated on July 05, 2014Privacy Policy