Drop down list in Excel Form box?

%3CLINGO-SUB%20id%3D%22lingo-sub-2633604%22%20slang%3D%22en-US%22%3EDrop%20down%20list%20in%20Excel%20Form%20box%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633604%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20all.%20Is%20it%20possible%20to%20create%20a%20dropdown%20list%20in%20the%20excel%20form%20box%3F%20I%20want%20to%20use%20the%20form%20to%20enter%20data%20into%20a%20table%20but%20I'd%20like%20to%20have%20drop%20down%20lists%20for%20a%20few%20of%20the%20input%20fields.%20Is%20this%20possible%3F%20If%20so%2C%20how%20to%20make%20this%20happen%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2633604%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2633665%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20list%20in%20Excel%20Form%20box%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633665%22%20slang%3D%22en-US%22%3EHi%20there%20!%20Could%20you%20attach%20a%20sample%20of%20the%20spreadsheet%20so%20I%20can%20see%20what%20you%20mean.%20Please%20remove%20all%20confidential%20data.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, all. Is it possible to create a dropdown list in the excel form box? I want to use the form to enter data into a table but I'd like to have drop down lists for a few of the input fields. Is this possible? If so, how to make this happen?

 

Thanks for any help.

2 Replies
Hi there ! Could you attach a sample of the spreadsheet so I can see what you mean. Please remove all confidential data.

@slocpc 

If you mean the Data Form, it unfortunately doesn't allow for dropdowns.

Former Excel MVP John Walkenbach had a nice replacement, but his website is no more. You can download the J-Walk Enhanced Data Form, however from this archive page: J-Walk Enhanced Data Form 

Select the version for Excel 2007.