Forum Discussion

slocpc's avatar
slocpc
Copper Contributor
Aug 10, 2021

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 possible? If so, how to make this happen?

 

Thanks for any help.

excel

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 10, 2021

    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.

  • Cambosity100's avatar
    Cambosity100
    Brass Contributor
    Aug 10, 2021
    Hi there ! Could you attach a sample of the spreadsheet so I can see what you mean. Please remove all confidential data. 🙂

Resources