How to Insert Date Picker control in O365 Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1920809%22%20slang%3D%22en-US%22%3EHow%20to%20Insert%20Date%20Picker%20control%20in%20O365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920809%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20can%20explain%26nbsp%3BHow%20to%20Insert%20Date%20Picker%20control%20in%20O365%20Excel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1920809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1920847%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20Insert%20Date%20Picker%20control%20in%20O365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920847%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F705002%22%20target%3D%22_blank%22%3E%40chamiralakmal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EDoesn't%20the%20calendar%20control%20work%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20control%20element%20%22Microsoft%20MonthView%20Control%206.0%20(SP4)%20can%20also%20not%20be%20found%20under%20other%20controls.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20nice%20thing%20about%20the%20Date%20and%20Time%20Picker%20is%20that%20you%20can%20provide%20a%20date%20input%20field%20with%20little%20effort%2C%20which%20always%20delivers%20a%20date%20as%20the%20result.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EDisplay%20the%20form%20in%20the%20VB%20editor%3B%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Eunder%20Extras%20%2F%20Additional%20Controls%20...%20check%20the%20entry%20'Microsoft%20Date%20and%20Time%20Picker%20Control'%3B%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EDrag%20the%20new%20'DTPicker'%20icon%20from%20the%20toolbox%20into%20the%20form.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EInsert%20a%20date%20picker%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Finsert-a-date-picker-afa0aea0-d4e3-4424-8e0a-c08f65928f84%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Finsert-a-date-picker-afa0aea0-d4e3-4424-8e0a-c08f65928f84%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EWhich%20Excel%20version%20of%20365%20do%20you%20have%3F%20...%20and%20which%20operating%20system%3F%20...%20if%20it%20doesn't%20work%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3Eand%20you%20would%20like%20to%20give%20us%20feedback%20(which%20I%20would%20be%20happy%2C%20especially%20if%20it%20works%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%20please%20specify.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Anyone can explain How to Insert Date Picker control in O365 Excel

4 Replies
Highlighted

@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...

 

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.

Highlighted
Thank You. My version O365 16 x32 bit
Highlighted
Windows 10 Business
Highlighted

@chamiralakmal 

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.