PDA

View Full Version : 'UserForm Calander Control



danielp1
03-20-2013, 01:06 PM
I really appreciate the 'UserForm Calander Control" article that 'lucas' posted a while back and hope someone may be able to help with a problem I am having.
It work s great on my computer; (Excel 10), but will not work on any other computers; (1 has Excel10, 3 have Excel 2007).
The only difference between them is that I installed CalandarControl 11;(MSCAL.ocx) on my computer a while back; {but this code was supposed to have no need for it}
The error I get on the other computers is: 'Compile Error--Can't find project or library'. The debuger stopes at 'ThisDay = Date'.
Thanks lucas for your innovative code. I have learned a lot from it for other projects.
Best Regards,
-dan-
(danielp1)

SamT
03-20-2013, 02:41 PM
Have you tried installing a calendar control on the other computers?

Jan Karel Pieterse
03-21-2013, 01:10 AM
In the VBA project in question, uncheck the calendar control as I understand you are no longer using it?

Jan Karel Pieterse
03-21-2013, 01:26 AM
I meant to say uncheck the calendar control in VBE's Tools, References.

danielp1
03-21-2013, 06:24 AM
That did it!!
Every time I come here I learn something new.
Thanks a million Jan!!!