Link to home
Start Free TrialLog in
Avatar of NormanMitchell
NormanMitchell

asked on

Calendar Control in Excel 2003 VBA

I have tried to add an additional control - the "Calendar Control" to a form in Excel 2003 VBA. I right click on the forms tool box, selecte "Additional Controls" but he calendar control does not appear. This has worked on a PC with both Excel 2003 and Excel 2007 loaded but not with a pc with just Excel 2003.

Any ideas please?
ASKER CERTIFIED SOLUTION
Avatar of clarkscott
clarkscott
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NormanMitchell
NormanMitchell

ASKER

Tried copying MSCAL.OCX to Windows\System32 folder - but Calnder Control still does nopt appear in "Additional Controls" when right clicking on the Forms toolbox and selectinf "Additional Controls".

Does MSCAL.OCX need to be ativated in some way?
The comment was the key that led me to the solution. The missing element was the need to register MSCAL.OCX.
Additional comment:
If you copy these things to the same folder where your application is run from, and you browse and load from this same folder, you don't have to register.
Scott c