View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JennLee JennLee is offline
external usenet poster
 
Posts: 14
Default Mscal.ocx on a UserForm to return selected date to WorkSheet

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.
--
Jennifer Lee
IS Coordinator/App Support