Excel VBA - Macro Runs When Worksheet Changed. http://blog.contextures.com/archives/2009/12/11/excel-vba-show-a-message-to-users/ Show a message in your Excel workbook by using a macro. Click OK to close message.
The message will only appear if a specific cell has a value that is listed in the macro code. In this example, the message appears for customers in Canada. If customer is in USA, message will not appear.
Then, add code to check which cell was changed, and only run the macro if the customer name was changed. This will prevent the macro from running when other cells are changed.
Tags: Excel VBA - Macro Runs When Worksheet Changed, Excel, Excel message box, Excel warning message, Excel VBA, Excel macro, Contextures, instructions, tutorial