Problem
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
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
Microsoft Monthview Control 6.0 Sp6 Excel 2010 Download
Scroll down and select Microsoft Date and Time Picker Control 6.0 (SP6) or Microsoft MonthView Control 6.0 (SP6) then click OK. When you are out of Design Mode, clicking on the DTPicker control is like this, while the MonthView takes more space. Fixing MSCOMCT2.OCX ActiveX Issues - How to Download and Repair. Last Updated: Time Needed for Reading: 4-6 minutes MSCOMCT2.OCX uses the OCX file extension, which is more specifically known as a Microsoft Common Controls 2 ActiveX Control DLL file.It is classified as a Win32 DLL (Dynamic link library) file, created for Microsoft Common Controls 2 Object Library by Innovative. Service Pack 6 for Visual Basic 6.0 provides the latest updates to Visual Basic 6.0. It is recommended for all users of Visual Basic 6.0. I've created a spreadsheet with a form that utilizes the Microsoft Date Time Picker 6.0 ActiveX control. It works just fine on my computer, but I've shared it for other people. Using Windows 7 64 bit and MS Office 2013 64 bit. Want to use datapicker in Excel. Found that MonthView Control is missing. Thus, download MSCOMCT2.OCX and place it inside C: Windows SysWOW64, then run regsvr32 to reg it successfully.