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.
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
Excel Monthview Control
- Good day all, I am trying to add a date picker to my UserForm but having no success. I was told that Microsoft Monthview Control 6.0 is what i need to check from the additional control tab in the vba toolbox. I tried accessing additional control from the tool box but did not see Monthview Control 6.0.
- Activate Control Tools-References Select 'Microsoft Windows Common Controls 2-6.0 (SP6)' Userform Controls Select any userform in VB project Tools-Additional Controls Select 'Microsoft Monthview Control 6.0 (SP6)' Use 'DatePicker' control for VBA UserForm; Hope you get.
- Visual Studio 6.0. The MonthView control enables you to create applications that let. Install the MSCOMCT2.OCX file in the user's Microsoft Windows System. I have a client who uses the date picker from Microsoft MonthView Control 6.0 (SP6). No ads, no trackers, no cookies and no registration. Saludos cordiales.