Use the Worksheet_Change() event macro. See

http://cpearson.com/excel/events.htm

In article ,
"qwerty" wrote:

In my data validation I put the minimum and maximum values in the
spreadsheet rather than hard code them. The problem is if the end user
changes the minimum or maximum value I want to run a macro to reset the
messages to be displayed by the data validation message box.

What I want to do is trigger the macro if either value changes. Cell M8
holds the minimum, N8 holds the maximum value. Value is integer. So if
either of these numbers are change, how do I automatically run my macro?