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

Place this macro in Sheet1.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(3, 1) = 0 Then Macro1
End Sub


--
raypayette


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

By changing the SelectionChange to just, Change, it works perfectly.

Thanks Ray.


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