Run a macro when a cell changes

[Pauljj]

Afternoon all, I have a drop down option in cell C4, when the user changes anything in that cell I want the macro 'depdate' to run

I have written this but nothing happens ?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("C4")) Is Nothing Then
        Application.EnableEvents = False
        Call Module2.depdate
    End If
    Application.EnableEvents = True
End Sub

 

[Pauljj]

But that will not run automatically when C4 is changed.

It errors when I leave the code in

 

[Fluff]

Oops, just realised I didn't post the code in post#8. Put his in a normal module & run it

Sub reset()
   Application.EnableEvents = True
End Sub

then put the code from post#4 in the relevant sheet module & change C4, does the code run?

 

[Pauljj]

Perfect, thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.