Custom DatePicker and Monthview no installations no add ins

[MrZNF]

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

 

[alansidman]

I use Ron deBruin's DatePicker. It is an add-in that can be found here: Date Picker Add-in for Excel for Windows

I like its simplicity. Right click on a cell and the Date Picker opens.

I could not get the MS DatePicker to load properly. It would not work for me at all.

 

[MrZNF]

I use Ron deBruin's DatePicker. It is an add-in that can be found here: Date Picker Add-in for Excel for Windows

I like its simplicity. Right click on a cell and the Date Picker opens.

I could not get the MS DatePicker to load properly. It would not work for me at all.

As I mentioned, I'd prefer to not have to ask the end-user to install anything.

This would potentially pose problem:
* in some cases my end-users don't have full administration rights to their computer
* they are not tech-savy

But most importantly, this is an extra step I don't want to impose on the end-user. And the silly thing is, it's available in Word! Why not in Excel? It seems superior to create user forms in Excel, except for the fact that the MonthView is not available anymore...

Anybody else with any experience in this area?

 

[MrZNF]

Sorry to double post bump this, but I'd be really grateful if anyone can share their experience with this tool:
https://sites.google.com/site/e90e50...OC-The-concept

and/or if there are better alternatives out there.