I have several fields that need to have a date entered ( i do this through a datepicker).
I want to make sure that one date is today or in the future, and the other atleast tomorow or in the furure.
I found this: [VBA]Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("c5"), Target) Is Nothing Then
MsgBox "c5 has changed"
End If
End Sub[/VBA]
Which makes a mssg apear if the value changes.
Now I want to change this code so it check the value itself (a date) and if it's not now or later, it should clear that same field and generate a message (so they have to try again).
possible?