- Greetings, I am trying to find the MonthView Control 6.0 in Excel 2016. I am using the x64 version and it is not displaying when using the Additional Controls option.
- I'm using Excel 2007 with Windows 7 and trying to make available the Microsoft Date and Time Picker Control 6.0 for a userform. Unfortunately, when I right-click the Toolbox and select Additional Controls, it doesn't appear in the list.
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
In the posting “Insert a Drop Down Calendar Menu In Excel – Choose a Date!” one of the steps requires that you select the Microsoft Date & Time Picker Control 6.0 (SP4).
6.0 Ford
Looking for it? Trying to figure out where to download it from? If it is not installed on your system you can download it here.
To unzip a CAB file simply follow the directions in the posting “A Free Alternative to Winzip or WinRar: 7-Zip”
How to Install Microsoft Date & Time Picker Control 6.0 (SP4) In the posting “ Insert a Drop Down Calendar Menu In Excel – Choose a Date! ” one of the steps requires that you select the Microsoft Date & Time Picker Control 6.0 (SP4). I cant find the Microsoft MonthView control 6.0 tool in Visual Basic for Excel 2013. 34 AM This forum is for Developer discussions and questions involving.
Once the file is unzipped simply run the MSCOMCT2.BAT batch file!
CategoriesUncategorized
Tags7-ZipCalendarDateDrop DownExcelMicrosoftTimewinrarwinzip
Microsoft Monthview Control 6 0 Excel 2007 Missing File
Related