Is it possible to write a macro that runs automatically when the value
of a cell changes and that cell has a formula.

For example: A3 = A1-A2 (e.g., 2-1=0)

Macro: if A3=0, then the macro runs.

I can get a macro to do this but only if I activate it manual, a
button, etc. I was wanting a macro to run just when a formula cell has
a certain value e.g., 0.

Would appreciate any help.


--
melafont
------------------------------------------------------------------------
melafont's Profile: http://www.excelforum.com/member.php...o&userid=36610
View this thread: http://www.excelforum.com/showthread...hreadid=568675