Activate macro when cell is ne to 0

[erricca]

Hi,
I would like a macro to run automatically when a cell (C32) is not equal to zero.
So when C32 is not equal to zero, this macro should run;
Sub NGWBC()
Worksheets("S9").Range("c32").GoalSeek _
* * * * * * * * * * Goal:=0, ChangingCell:=Range("C33")
* * End Sub
Thanks
Erica

 

[Jon von der Heyden]

What's in C32? A constant or a formula?

 

[erricca]

What's in C32? A constant or a formula?

Thanks for replying...
It is a formula cell (C33-C31 is the formula)?

 

[kolle_hond]

It should be something like this

Private Sub Worksheet_Change(ByVal Target As Range)
If ActiveSheet.Range("C32") <> 0 Then
NGWBC
End If
End Sub