SOLVED

Excel calendar objects

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3033375%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EExcel%20calendar%20objects%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3033375%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EIs%20there%20a%20calendar%20date%20picker%20object%20available%20for%20Excel%20data%20entry%3F%20If%20not%2C%20then%20why%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3033375%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EMacros%20and%20VBA%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3037428%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ERe%3A%20Excel%20calendar%20objects%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3037428%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%5C%26quot%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%40Sergei%20Baklan%26lt%3B%5C%2Fa%26gt%3BThanks%20for%20your%20perspective%20and%20I%20will%20add%20a%20vote%20for%20improving%20the%20interface%20methods%20used%20for%20excel%20data%20entry%2C%20especially%20since%20it%20would%20be%20a%20really%20handy%20tool%20using%20a%20very%20simple%20pop%20up%20format.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3036399%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ERe%3A%20Excel%20calendar%20objects%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3036399%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1243454%5C%26quot%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%40WFCIVIL%26lt%3B%5C%2Fa%26gt%3B%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FA%3E%3C%2FP%3E%3CP%3EDate%20Picker%20is%20not%20available%20out%20of%20the%20box%20in%20modern%20Excel.%26nbsp%3B%20It%20had%20lot%20of%20voices%20in%20former%20uservoice%2C%20not%20sure%20if%20that%20request%20was%20moved%20to%20new%20feedback%20portal.%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3EWhy%3F%20I%20don't%20think%20someone%20has%20exact%20answer.%20Even%20Microsoft%20has%20limited%20budgets%2C%20and%20that's%20always%20the%20compromise%20to%20spend%20money%20on%20development%20of%20new%20functionality%20and%20make%20Excel%20more%20modern%20or%20make%20more%20focus%20on%20support%20backward%20Excel%20functionality%20starting%20from%20Excel%2095.%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3EDate%20picker%20in%20modern%20Excel%20could%20be%20considered%20as%20new%20functionality%2C%20but%20it%20looks%20like%20it%20has%20low%20priority.%20You%20may%20add%20your%20vote%20on%20feedback%20portal%20to%20make%20its%20priority%20higher.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3036384%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ERe%3A%20Excel%20calendar%20objects%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3036384%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EThe%20UserForm%20in%20the%20Word%20template%20in%20the%20Calendar.zip%20that%20you%20can%20download%20from%20the%20following%20page%20of%20Graham%20Mayors%20website%20can%20by%20used%20in%20as%20a%20UserForm%20in%20Excel%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22%5C%26quot%3Bhttp%3A%2F%2Fwww.gmayor.com%2Fdownloads.htm%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnofollow%20nofollow%20noopener%20noreferrer%22%20noopener%3D%22%22%20noreferrer%3D%22%22%3Ehttp%3A%2F%2Fwww.gmayor.com%2Fdownloads.htm%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3C%2FA%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Is there a calendar date picker object available for Excel data entry? If not, then why?

3 Replies
best response confirmed by WFCIVIL (New Contributor)
Solution
The UserForm in the Word template in the Calendar.zip that you can download from the following page of Graham Mayors website can by used in as a UserForm in Excel

http://www.gmayor.com/downloads.htm

@WFCIVIL 

Date Picker is not available out of the box in modern Excel.  It had lot of voices in former uservoice, not sure if that request was moved to new feedback portal.

 

Why? I don't think someone has exact answer. Even Microsoft has limited budgets, and that's always the compromise to spend money on development of new functionality and make Excel more modern or make more focus on support backward Excel functionality starting from Excel 95.

 

Date picker in modern Excel could be considered as new functionality, but it looks like it has low priority. You may add your vote on feedback portal to make its priority higher.

@Sergei BaklanThanks for your perspective and I will add a vote for improving the interface methods used for excel data entry, especially since it would be a really handy tool using a very simple pop up format.