Home

adding a drop down calender in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-745940%22%20slang%3D%22en-US%22%3Eadding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745940%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20a%20beginner%20with%20excel.%20I'm%20trying%20to%20figure%20out%20how%20to%20make%20a%20calender%20pop%20up%20when%20clickingon%20a%20drop%20down%20menu.%20I%20have%20office%2016.%20Any%20help%20would%20be%20appreciated.%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748235%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748235%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373638%22%20target%3D%22_blank%22%3E%40Patrick0826%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ECommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20Excel%20space%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748579%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748579%22%20slang%3D%22en-US%22%3EI%20strongly%20suggest%20that%20instead%20of%20a%20calendar%20drop-down%2C%20you%20use%20a%20date%20drop-down.%20The%20first%20allows%20any%20date.%20The%20second%20limits%20the%20input%20date%20to%20those%20included%20in%20the%20drop-down.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750066%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750066%22%20slang%3D%22en-US%22%3E%3CP%3EOk%2C%20will%20do.%20Thanks!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750067%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750067%22%20slang%3D%22en-US%22%3ENo%20problem%2C%20thanks!%3C%2FLINGO-BODY%3E
Patrick0826
New Contributor

Hi, I'm a beginner with excel. I'm trying to figure out how to make a calender pop up when clickingon a drop down menu. I have office 16. Any help would be appreciated. Thanks!

 

4 Replies

@Patrick0826 

Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

I strongly suggest that instead of a calendar drop-down, you use a date drop-down. The first allows any date. The second limits the input date to those included in the drop-down.

Ok, will do. Thanks!@Twifoo 

No problem, thanks!