![]() My thanks for the class code go to the authors. As per the authorized statement from the moderators of, MS Excel’s Date Picker feature is available only in 32-bit versions of Excel 2016, Excel 2013, and Excel 2010, but the default Date Picker feature won’t work on Excel 64-bit. The ActiveX control only ran on 32 bit systems, but this date picker class runs on any version of Excel both 32 and 64 bit. An easy to use VBA class, with examples to download in a workbook. I thought I’d found one in the shape of the calendar control, but surprise surprise, this too was missing from that user’s PC. An Excel date picker (calendar) for all versions of Excel, both 32 and 64 bit. According to reports from Microsoft, the traditional date picker tool (called MSCAL.OCX) was shipped with Office 2007, but is not included in later versions of. Ideally I’d like to find an alternative to the DTPicker. However, I can’t work out a way to do this as this particular user doesn’t have admin rights – also this problem is likely to occur in the future as other users trash their machines and require them to be re-built. The simple fix would be to install the mscomctl2.ocx on the user’s PC. I worked out that they had had their PC re-imaged so had never had Office 2003 installed therefore they never had mscomctl2.ocx on their system (the tool uses the datetimepicker control form this library). Then the other week a user complained that they were unable to use the tool. It took a bit of work to get the tool working in both environments, but this was donw and all seemed well. Now I need to add a date picker to a spreadsheet and it seems that isn't possible without going 3rd party. Then most of our users were upgraded to 2007. how do I add a date picker to an excel spreadsheet if I was unfortunate enough to get the 64 bit version of Office 365 I'm not even sure I made a selection, that's just what got downloaded. I developed a tool in Excel 2003 that was in use for a whole year without issues. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |