Solved How to modify a drop-down menu in Excel 2010

Dell / Inspiron 17r
May 9, 2018 at 05:52:45
Specs: Windows 10, 2.3/8
I can create drop-down menus in Excel 2010. Is it possible in a drop-down menu to have a listing where the choice is typed in? As an example, the drop-down menu lists “red”, “green” and “blue” but the correct answer would be “yellow”.

Thank you.
Brian W


See More: How to modify a drop-down menu in Excel 2010

Reply ↓  Report •

#1
May 9, 2018 at 06:03:10
✔ Best Answer
In the Data Validation dialog box, click the Error Alert tab. Then uncheck the "Show error alert..." option.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
May 9, 2018 at 08:22:50
If you want to make it clearer for your users, you could add a choice for "Other - Enter Answer".

Even though they'll actually be able to type over any choice that they make, the "Other..." choice serves as an instruction of sorts. Some users may not realize that they can type in the cell and not know what to do if the correct answer isn't on the list. Let them choose "Other..." and then start typing.

They'll feel more empowered. ;-)

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#3
May 9, 2018 at 09:00:18
DerbyDad03,

Thank you for your assistance. I used “Other - Enter Answer” and besides being a great idea, the menu worked fine.

Brian W


Reply ↓  Report •
Related Solutions


Ask Question