Excel VBA - date format and Active X

Hi

I have no idea what happened to the Active X calendar control in Excel 2010
so I have built 3 ComboBoxes with day, month and year.
What VBA do I use to gather the integer date from these 3 boxes and compare
it to a cell value of "2010/12/31"
thanks
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
SiddharthRoutCommented:
If I am not wrong then MSCAL.OCX is only available for 64 bit Excel 2010. I have a 32 bit system and I am also having a tough time with that.

Sid
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much Sid
0
 
SiddharthRoutCommented:
murbro: I suggest you should have waited for some more time before selecting an answer. I am sure there are several mvp's who could have confirmed what I said is correct or not.

Sid
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.