Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
date comparison help | Excel Discussion (Misc queries) | |||
Date Comparison with VLookup | Excel Worksheet Functions | |||
Date comparison | Excel Worksheet Functions | |||
Date comparison | Excel Discussion (Misc queries) | |||
Excel - date comparison | Excel Discussion (Misc queries) |