Checkbox1.Enabled = (Combobox1.Value = "January" And Date <
DateSerial(2004,02,02))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"abxy " wrote in message
...
ok, i've just come up with an idea, i'm thinking that maybe i could put
a little something in like this (for the example's sake let's say that
the specified date is 2/2/04):

If Combobox1 = "January" And [the date is not
equal to the specified date(2/2/04) or later] Then

Checkbox1.Enabled = False

End if

Ok, now the only problem is, what's the code for "the date is not equal
to the specified date or later" part

Any help?


---
Message posted from http://www.ExcelForum.com/