Excel Fox
07-17-2013, 12:27 AM
I was working on a project which required a date and time control. As I expected, the MSComCtl.ocx, or the Microsoft Windows Common Controls 6.0 (SP4) did not work in many of the computers that the project was run on. As I searched the internet, I came across quite a few sites which have very good looking non-activex, non-MSCAL.OCX calendar forms, and hot discussions on the same.
https://sites.google.com/site/e90e50/calendar-control-class
http://www.tushar-mehta.com/excel/software/tm_calendar/index.html (http://www.linkedin.com/redirect?url=http%3A%2F%2Fwww%2Etushar-mehta%2Ecom%2Fexcel%2Fsoftware%2Ftm_calendar%2Find ex%2Ehtml&urlhash=YJPf&_t=tracking_disc)
ActiveX date and time picker not available in Excel 2010 - any alternatives? | LinkedIn (http://www.linkedin.com/groups/ActiveX-date-time-picker-not-3843467.S.201737752)
But alas! None of them had a Time Picker (or nobody seemed to be really interested in time, and very mostly focused on date)
Anyway, I put together this very very crude but reliable piece of interface that replicates an actual time picker control. It's really straight forward, but just be sure you which events to use to call the right forms to pick date and time. Until I am forced to work on a more close-to-original replica, or until I improve my googling skills, I'll leave this for your usage. In the same vein, let me emphasize that this is more of a developer's version than a production version.
https://sites.google.com/site/e90e50/calendar-control-class
http://www.tushar-mehta.com/excel/software/tm_calendar/index.html (http://www.linkedin.com/redirect?url=http%3A%2F%2Fwww%2Etushar-mehta%2Ecom%2Fexcel%2Fsoftware%2Ftm_calendar%2Find ex%2Ehtml&urlhash=YJPf&_t=tracking_disc)
ActiveX date and time picker not available in Excel 2010 - any alternatives? | LinkedIn (http://www.linkedin.com/groups/ActiveX-date-time-picker-not-3843467.S.201737752)
But alas! None of them had a Time Picker (or nobody seemed to be really interested in time, and very mostly focused on date)
Anyway, I put together this very very crude but reliable piece of interface that replicates an actual time picker control. It's really straight forward, but just be sure you which events to use to call the right forms to pick date and time. Until I am forced to work on a more close-to-original replica, or until I improve my googling skills, I'll leave this for your usage. In the same vein, let me emphasize that this is more of a developer's version than a production version.