run a macro when I change/update the value in a cell

[SKooLZ]

Hi guys, I need help which a vba code to make excel automatically run a macro when I change a value in any cell of a specific column. I have come up a modification of the following code which is not working:

19 = target column
testing spreadsheet = spreadsheet in question
Refreshfilter = macro to run



Private Sub Status_Change(ByVal Target As Range)


Dim oldVal As String
Dim newVal As String


If Target.Count > 1 Then Exit Sub
If Target.Column = 19 Then

'If Target.Column <> 100 Then
newVal = Target.Value
If newVal <> "" Then
Application.EnableEvents = False
Application.Undo

Application.Run "'testing spreadsheet'!Refreshfilter"

Else
End If

Application.EnableEvents = True

End If
End If

End Sub


Thanks in advance.

 

[Gary McMaster]

Looks like you have changed the name of the "Worksheet_Change" procedure to "Status_Change" hence it will not be recognized as an event. Try placing your code in the "Worksheet_Change" event.

 

[SKooLZ]

Great, Gary, thanks, thats sorted it out!

The more I learn more about Excel, the more I realise that there's more to learn!!