Thread: Date comparison
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TOMD TOMD is offline
external usenet poster
 
Posts: 33
Default 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