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

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

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