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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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?
 
Back
Top