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

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

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


"JennLee" wrote:

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

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

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


"JennLee" wrote:

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


"JennLee" wrote:

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