Change event

[micko1]

Looking for code that will look for change event in column "G" named range "Rego". Then check to see if the value (which is a date) in column "M" is less than value in column "G" ( also a date ) if answer is yes then delete the value in column "M".

 

[Von Pookie]

Try this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Intersect(Target, Range("Rego")) Is Nothing Then Exit Sub
Application.EnableEvents = False
If Target.Value < Cells(Target.Row, "M").Value Then Cells(Target.Row, "M") = ""
Application.EnableEvents = True
End Sub

 

[micko1]

Kristy
Thanks very much you have solved another little dilema I had. I would like to thank you very much for your assistance. The code you gave me is exactly what I was after. I bow to the gurus.

Mick