UserForm from 2003 to 2007 1

[Groves22]

I have two computers at my desk. 1 uses Excel 2003, the other uses 2007.

I created a UserForm calendar using the following websites method.

http://www.fontstuff.com/vba/vbatut07.htm

When I try to run the macro that used this form in Excel 2007, the VBA is bombing out. I tried to follow the steps in 2007 to recreate the calendar, but I can find the "Calendar Control X.X" in the Additional Controls selection box.

Any ideas?

 

[DaveInIowa]

I believe the calendar control is installed with MS Access. If you don't have MS Access, install the control (MSCAL.OCX) independently.

 

[Groves22]

I believe the calendar control is installed with MS Access. If you don't have MS Access, install the control (MSCAL.OCX) independently.

Ah... My 2nd machine doesn't have Access. How do I go about installing it independently?

 

[DaveInIowa]

http://www.fontstuff.com/mailbag/qvba01.htm

 

[Groves22]

Thank you!