Date and Time Picker & Monthview controls are not included as a standard since Excel 2010 (additionally there are some known issues).
So the additional controls are buggy (>download< - >step by step<):
Microsoft Date and Time Picker Control 6.0 (SP6)
Microsoft MonthView Control 6.0 (SP6)
And I would need to explain to the end user of my form, how to install it.
Ideal situation
The end user does not need to install anything in order for the macro to work.
Research
So I did some research and found the following website: https://sites.google.com/site/e90e50/calendar-control-class#TOC-The-concept
Claims (I believe) to be easy to implement in existing Excel projects and compatible with older versions and only to use basic elements.
Alternatively: Use a Calendar control or Date Picker to fill in dates provides an Excel Add In.
This would still require all end-users to install the add in. Something I'd prefer to avoid.
My question
Is the Calendar Control Class the golden nugget I've been looking for? I need to apply it to two cells on one sheet in my workbook.
If yes, I'm going to try and implement it
Curious to hear about people their experience with it.
Thanks for your input!
Cheers,
Zeno
I have find MicroSoft TreeView Control 6.0(SP6) Microsoft Date and Time Picker Control 6.0 (SP6) question, Jul 23, 2007, in forum: Excel Misc. Use the Value property to convert the current text into a DateTime variable and return. This is to aid in sizing the control. 26 Aug, 2015 Admin Post navigation. ‘Microsoft Date and Time Picker Control 6.0 (SP6)’ is not available for the 64-bit version of MS Excel. After writing the VBA code, we need to save the file with ‘.xlsm’ (Excel Macro-Enabled Workbook) extension; otherwise, the VBA code would not run. Recommended Articles. This has been a guide to an excel date picker. If you are running 32-bit version of Excel, generally we could take the steps you have mentioned in your thread to register the calendar control in your system. I tested in my current Excel 2013 (32-bit) and Windows 10 (64-bit) by following the detailed instructions in the article below and the control can be registered properly. I've developed a tool using VBA in Excel 2002 (XP) and I have used the Microsoft MonthView Control 6.0 (SP6). I need the workbook and attached form to work on a Windows XP machine that doesn't have MSCOMCT2.ocx installed. Due to administrator restrictions on each machine (and the resources required to update each and every machine with this.
Microsoft Monthview Control 6 0 Sp6 Excel 2010 Download 64-bit
I would recommend not to use monthview control. You may use this alternative. If you still want to use the monthview control then see this. The MonthView1 controls return a string value which can be accessed by MonthView1.Value. And once you have the string value, you can convert that to a date value by using CDate For example.