Can anyone please tell me how to catch an cell change event due to formula, for example if at cell A3 has got formula =A1+A2, now if the value of A1 has changed then it reflects the value A3 too, but I am not able to get the cell change event on that.
I have got following KB article for that, it catches cell change event but not catch if a value of cell is changed due to a formula.
http://support.microsoft.com/kb/823981
Thanks,
Mushq
