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!
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!
