i'm creating a UserForm in VBA and I've run into a little challeng
which at the moment i just don't have an answer to, so i'm turning her
for help. Here's my problem:

I have a combo box with the months January thru Decemeber as possibl
selections, then I have 4 checkboxes for weeks 1 thru 4 of the months
I would like to somehow make it so that if, the current date isn'
passed a particular date certain checkboxes aren't enabled.

As an example, let's say today is January 2 ...so I select January fro
the combo box, but now only the checkbox for Week1 should be enable
since it's only the first week of January. Now if today was January 8
then the checkboxes for Week1 and Week2 should be enabled becuase it'
past Week1 of January and it's Week2.

So basically i'm asking for help on the code to say: the value of th
combo box determines the month, and if it's not past a certain day o
that month then this checkbox shouldn't be enabled.

Thanks in advance for any and all help. I really appreciate it

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