Mscal.ocx on a UserForm to return selected date to WorkSheet

J

JennLee

I have found several posts so very helpful regarding the Calendar Control,
following the instructions given for creating a Pop-up Calendar for Excel
storing in Personal.xls. But I desperately need a calendar control to work
for me like the mscal.ocx does on my personal computer. The Excel UserForm
I've created for my staff to simply enter their activity in a custom user
form with values being returned to the pre-formatted worksheet in the
workbook is perfect, except for the Calendar. I found a DTPicker and used
that on my personal computer as well but the problem lies in the fact that I
can't register the .ocx on all the end user's machines because we log in
through Citrix and don't have access to register the mscal.ocx in the
Windows\System folder on work laptops. I would love to share what I've done
to get some direction. Any help would be greatly appreciated.
 
J

JennLee

I'm replying from my personal PC only to attach my IP Address in case anyone
can help with my problem stated below. Thanks in advance for any help.
 
J

JennLee

I just went back into my project and I actually had ended up with a DTPicker
control which is exactly what I want but it stems from Visual Studio 2005
Express that I have loaded on my PC and it's not on our work laptops which is
where I need to distribute this UserForm. Any takers?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top