Forum Discussion
Drop down list in Excel Form box?
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 ...
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.