Message box to display on value change/inside a range

[trade]

Hi

I found this thread that shows how to create a msgbox if a value changes in a cell. I wonder if it will also work if target cells are formulas?

Also will the msgbox only appear in the sheet where the macro is stored in? Will it only appear if I enter that sheet?


Basically I need msgboxes to appear when values in formulas change and I need them to appear in the current sheet I am working in.


http://www.excelforum.com/excel-prog...-on-value.html

[sktneer]

May be like this.....
Place this code on ThisWorkbook for Sheet Calculate Event.

Please Login or Register  to view this content.