I didnt find Microsoft date picker in excel
I didnt find Microsoft date picker in excel
MS Date Picker has various issues and does not work for 64 bit install of Excel.
Instead, use one of many custom date pickers you can find in the web.
Ex:
https://trevoreyre.com/portfolio/excel-datepicker/
https://www.rondebruin.nl/win/addins/datepicker.htm
http://samradapps.com/datepicker
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Should work in 365.
Click any cell A2 to A100.
can u tell me how you did it
It is a simple VBA/UserForm with three comboboxes & a command button.
Right click on Sheet1 tab dropdown menu select 'view code' this is the worksheet event that triggers the 'datepicker' and intercepts the 'target cell'.
The rest of the code is in the UserForm.
I tried to submit the code (between code tabs) however site firewall blocked it thinking it was HTML.
torachan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks