This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a drop down box in Excel...I want to also be able to enter a free form entry in that same cell as well as have the option to use the drop down list. HOW do I do that, and what's the terminology...for some reason, this isn't discussed as a DROP DOWN LIST issue.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Uncheck "Show error alert when invalid data entered"
If you want the free form entry to become a permanent member of the dropdown list you must employ VBA event code.
The code and a sample workbook can be found at Debra Dalgleish's site if interested.
http://www.contextures.on.ca/excel-data-validation-add.html
Gord