Date Picker for Excel 64bit

[Negi1984]

Hi All,

I have a Master workbook in SharePoint online location. everyday ~10-15 users from multiple region are updating that workbook.
In that file we have one column related to Date and every time I found that somebody entered a date in Text format. So to avoid this issue I am thinking to solution based on Date picker.

But after google search I found default option of Date picker is not available in 64bit version.
Can anybody help me out how to achieve this goal ?

 

[braindiesel]

Microsoft removed the datepicker. No idea why. It is among the most frequently requested additions.

Ron DeBruin has an add in. I have not tried it yet but he has a good a reputation as there is with excel.

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

 

[NoSparks]

Do a Google search for "Trevor Eyre Date Picker Userform"

 

[Negi1984]

Microsoft removed the datepicker. No idea why. It is among the most frequently requested additions.

Ron DeBruin has an add in. I have not tried it yet but he has a good a reputation as there is with excel.

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

Thank you Braindiesel,

 

[Negi1984]

T

Do a Google search for "Trevor Eyre Date Picker Userform"

Thank you NoSparks.

 

[NoSmoke]

Deleted.

 

[NoSmoke]

Microsoft removed the datepicker. No idea why. It is among the most frequently requested additions.

Ron DeBruin has an add in. I have not tried it yet but he has a good a reputation as there is with excel.

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

Just tried it and it works a treat (Excel 2010, 64 bit)! Thanks to you and to Ron DeBruin!