Macro on Cell change

  • Thread starter Thread starter melafont
  • Start date Start date
M

melafont

Is it possible to write a macro that runs automatically when the valu
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,
button, etc. I was wanting a macro to run just when a formula cell ha
a certain value e.g., 0.

Would appreciate any help
 
Place this macro in Sheet1.

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