Need a VBA Calendar that is NOT MSCAL.ocx

I'd like to use the Calendar ActiveX component, but it's giving me headaches because MS decided not to ship/install/activate it consistently. I have a Windows 7 system that gets an error because it is not installed... all my other test system seem to have it configured and working correctly (XP & Vista).

So I have some options....

Option 1
If I could detect the missing Cal functionality at the start of my program, I could avoid the "Could not load an Object because it is not available on this machine." error to the user -- then tell then to go off and install it. Yea - like that's real friendly

Option 2
I could rework my installer to install a version of the MSCAL.ocx but which version? If I install a newer version on an older OS will that give me issues? or break existing functionality?

Option 3
Don't use the calendar object at all, just create 3 drop-down values, one for the month, day & year. Allow the user to pick from those and forget the pretty calendar.

Option 4
Find something or someone that has created a Calendar that does not require the use of the possibly missing MSCAL.ocx.

I'm leaning towards option 3.

Thanks,

See the options here under datepicker

http://excel-it.com/free_addins.htm

I would suggest that you use the combobox example.

I'm working on a new version that can be used as part of the userform,keep an eye on the site for updates