Nov 21 2020 12:23 PM - last edited on Nov 09 2023 11:10 AM by
Anyone can explain How to Insert Date Picker control in O365 Excel
Nov 21 2020 12:52 PM
Doesn't the calendar control also work?
The control element "Microsoft MonthView Control 6.0 (SP4) can also not be found under other controls. The nice thing about the Date and Time Picker is that you can provide a date input field with little effort, which always delivers a date as the result.
Display the form in the VB editor;
under Extras / Additional Controls ... check the entry 'Microsoft Date and Time Picker Control';
Drag the new 'DTPicker' icon from the toolbox into the form.
Insert a date picker
Which Excel version of 365 do you have? ... and which operating system? ... if it doesn't work
and you would like to give us feedback (which I would be happy, especially if it works :) please specify.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Nov 21 2020 01:07 PM
Nov 21 2020 01:43 PM
For Windows platform it's coming, you may add your vote here Add 'date picker' to enable users to select a date from a mini calendar into cells Not sure about other platforms (365 Online, Mac, Android, iOS).
Alternatively you may google for third-party solutions, have no experience with them and don't know if they are reliable or not.
Oct 28 2022 08:06 AM
This does not work. I do not have the Date Picker option in the dropdown list.
Nov 10 2022 01:29 PM
Jun 23 2023 02:43 PM
@DianeDennis date picker still doesn't appear in the list , any solutions?
Thank u
Jun 24 2023 04:59 PM
How about webbrowser?
Jun 24 2023 05:39 PM
@peiyezhu thank u for replying
I added the date picker calander on the excel sheet in the top row of the table and freezed the top row, so users can easily view the calander then select the cell where the dates need to be entered then choose the date of the date picker calander , this can be a convenient quick solution as well
Will check out the link thank you:folded_hands:
Jun 24 2023 09:41 PM
Jun 25 2023 12:40 AM
Insert Date Picker in Excel (Office 365) on a Windows 64-bit Machine
http://samradapps.com/datepicker/
http://www.rondebruin.nl/win/addins/datepicker.htm
Jun 30 2023 09:12 AM
Jun 30 2023 04:28 PM