User-friendly date selection

dotsent

Board Regular
Joined
Feb 28, 2016
Messages
74
Office Version
  1. 365
Platform
  1. Windows
Hi! I need users to enter a date into Excel cell. However it needs to be in a controlled, but user-friendly manner. So, I can't just let users manually edit the field for date formatting problems as well as typos. I'm thinking of some nice graphical calendar view perhaps.

I have another requirement at hand - while there are extra add-ins for Excel that look to provide that (Microsoft Date and Time Picker Control ?), it would create too much trouble in case it has to be separately installed for every user involved and I'm looking at something already available within Office365 package that I'm using. VBA / userform option is fine though.

Any good practices to share? My go-to option would be to lock a cell with TODAY() formula and add + / - command buttons with VBA scripts to scroll that date by 1 day. But perhaps there's a cooler option than that plain one (missing the graphical calendar view)? Or am I looking for something that doesn't exist?

Thanks!
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

dotsent

Board Regular
Joined
Feb 28, 2016
Messages
74
Office Version
  1. 365
Platform
  1. Windows
Thanks, looks promising. Will dig deeper and try it out.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,983
Messages
5,575,371
Members
412,657
Latest member
georgean
Top