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
Highlighted

@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 

No problem, thanks!
Related Conversations
Excel for Mac - Point as separator in a German Excel
Mr_Geo91 in Excel on
0 Replies
Recovery & Solving the problem
Seve16640 in Excel on
0 Replies
Imported mdb tables not opened in the same Sheet
JozefMJ in Excel on
0 Replies
Excel freezes in secondary monitor
manuelzamora in Excel on
0 Replies
Add a watermark in Excel
SE_Duggins in Excel on
0 Replies