Microsoft Monthview Control Vba
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 Missing
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. Mainstream Support for Microsoft Visual Basic 6.0 ended on March 31, 2005. However, we are releasing this non-security related package because it contains improvements that were ready for release just prior to the end of Mainstream Support. Microsoft Visual Basic 6.0 has transitioned to Extended Support which runs through March 31, 2008. But when i open the developer tab,i have find no month view control. I am using Wind 10(32 bit) with 64 bit processor and my ms office is 2016. Please let me help and guide me in detail to solve this problem.