Run Macro when a Specific Cell value changes Automatically in Excel

[naira]

Hi!

I need to run macros when specific values in specific cells are automatically updated in excel. The values are updated through data update or through calculations in excel.

As a test case, following macro is expected to give a Message box when cell value is equal to 1 OR 2 OR A in cell A1. Macro is entered in the Excel Sheet.

The Macro runs properly when 1 or 2 or A is manually entered in cell A1. However, in case the values in cell A1 are results from some calculations, the message box does not appear.

Please Login or Register  to view this content.

How to modify the above code to also handle values updated through calculations OR is there any other more efficient code that I could use. (Please note that I am not looking for a SheetChange event, but only a specific value appearing in a specific cell of a specific sheet).

Note: Sample file attached with timer macro to show that the message box does not appear if values in cell A1 are automatically updated.

Thanks.

[JLGWhiz]

The Worksheet_Changee event ignores changes initiated by calculation. To capture the calculation event, you would need something like:

Please Login or Register  to view this content.

[naira]

The Worksheet_Changee event ignores changes initiated by calculation. To capture the calculation event, you would need something like:

Thanks.
Works great!!

[JLGWhiz]

You're welcome,
Regards, JLG