How to Insert Date Picker control in O365 Excel

chamiralakmal 

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

https://support.microsoft.com/en-us/office/insert-a-date-picker-afa0aea0-d4e3-4424-8e0a-c08f65928f84?ui=en-us&rs=en-us&ad=us

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.