Drop down list in Excel Form box?

[slocpc]

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]

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

[#3]

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