Trigger Macro when a cell value changes

Hello again. It has been a while since I've been on. I haven't done any programming for a long time. I have a worksheet where I would like to trigger a macro that I've written when a cell value changes. The cell value is calculated using a formula so the event needs to be triggered by the value changing not hitting enter in the cell. I can trigger the event using the following

Please Login or Register  to view this content.

I would like to change it so that it only calls the macro Fill if the calculated value in Column N changes. The above is an uneducated programmers way of cheating the system so that it always triggers no matter which value I change. This makes it trigger when any number is changed though. I only want it to trigger when a number that effects the calculated value in Column N is changed.

Thanks again for your help.

Thanks xladept. That doesn't work as that is what I started with. If I type a value in that range it works but as the value in that range is calculated by a formula it doesn't seem to work. EG. if I type a number in say C6 then the value in N6 will change but this doesn't trigger the call function if I use the code you have shown. Is there some other setting I may have turned off that I need to turn on.

Try this worksheet event

Please Login or Register  to view this content.

Thanks kvsrinivasamurthy, I hadn't seen that function before. I did a little research on it and from what I can see it triggers if any calculation in the entire worksheet occurs. Is there a way to limit it to if a calculation occurs in a set range. Thanks again.

Pl see attached file. It is an example.

Selected range is B4:E6
See the formulas in that range
change in K3,K4 and L5 bring changes in the range B4:E6 and calls "Fill" macro
"Fill" macro types a text in A1 in this example.

H1 has formula
change in H2 changes H1 value
This does not call macro, because it is not in selected range.

Code used for worksheet events

Please Login or Register  to view this content.