Drop-down list as suggestion

[happyhungarian]

Hi, I have a cell that requires user input. I would like there to be a drop-down in that cell that would allow a user to select some potential options. However, if the options don't work for the user or they want something else, they would still be able to type in whatever they'd like without being stopped by the data validation. Possible?

Thanks!

 

[My Aswer Is This]

You can use Data Validation:
Instead of choosing Stop as your Data Validation choice in the Data Validation setup choose Warning.
Then your able to enter any value you want.

In the Styles Box choose Warning instead of Stop

 

[happyhungarian]

So easy! I love it! Thank you

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

So easy! I love it! Thank you