Date Picker 64-Bit Excel 2013

I'm wondering if anyone has a good date picker they use in their projects and is willing to share?

I would like to have a shortcut that opens the date picker and returns the selected value into the current active cell.

this has served well for years and works with 64bit - right click on cell

This one has also be around for years.
Do not know if it always runs well, but have used it many times without problem, nice and compact.
Same process, right click in cell, drop-down menu, select insert date.
torachan.

Originally Posted by torachan

This one has also be around for years.
Do not know if it always runs well, but have used it many times without problem, nice and compact.
Same process, right click in cell, drop-down menu, select insert date.
torachan.

I get this error when I open the file.

Annotation 2019-06-12 205709.jpg

Originally Posted by nigelog

this has served well for years and works with 64bit - right click on cell

Thanks but when I choose a date with day greater than 12 I get the date as text.

Annotation 2019-06-12 210403.jpg

@kersplash
formatting in code probably needs attention

Originally Posted by nigelog

this has served well for years and works with 64bit - right click on cell

Also nothing comes up in the menu when I right-click in a cell.

Originally Posted by nigelog

@kersplash
formatting in code probably needs attention

There's only about 5 lines of code, unless I'm missing something?

Originally Posted by nigelog

Check code for form itself - I cant replicate your problem but I was forcing format to dd/mm/yy as I needed that output
each of the 42 button codes will need to be edited with find/replace

the right click was removed in that version - this should suffice

Ahhh. Got it in the form code now. Thanks.

Originally Posted by CK76

The one in link is my pick, when I have to use one. Though I tend to avoid use of date picker/calendar forms.
https://trevoreyre.com/portfolio/excel-datepicker/

This one does look nice. Why not use a date picker?

Originally Posted by CK76

I prefer keyboard entry
Ex: Validation on keyup event on textbox or datevalue validation in a cell.

Only time I use it, is when day of week alignment becomes important for data entry (and for other users).

Understood.