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

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

Ok, will do. Thanks!@Twifoo 

Highlighted
No problem, thanks!
Related Conversations
Excel Find and replace
Brickson_Dimas in Excel on
0 Replies
Excel on iPad
Mattlewis in Excel on
2 Replies
Help with excel
Alexvez01098 in Excel on
10 Replies
Rotate data from single cell to vertical listings
WEI_Bob in Excel on
2 Replies
2 Seniority Lists
Aminam20 in Excel on
9 Replies