Date comparison
I have a Named Range/Cell, "JanMtg". In my program, I have the following
statements:
Xval = 0
If CheckBox1.Value = True And Range("JanMtg").Value <= Date Then
Xval = 1
Else
MsgBox "Attendance data must be historic. Please select an earlier
month!"
GoTo AllDone
End If
I've tried every combination that I can think of and still the date test
fails. Without the date test it works fine. Any help will be greatly
appreciated.
Tom
|