How to use a dropdown OR text option

< Back to Search results

 Category: [Excel]  Demo Available 

How to use a dropdown OR text option




The user is trying to create a spreadsheet where certain cells have the option of either typing text into them or choosing from a standard option. Obviously the user can use data validation on a cell to create a dropdown that helps select that standard option but the user wants to be able to type in the same cell if required. 

Is there a way of using VBA code to detect whether a cell using data validation has had text entered into it and therefore bypass the error pop-up and keep the text entered in the cell? Or an even a way of doing it without VBA?




Switch off the error alerts

  1. Select all the data validation cells where you want to allow other entries
  2. On the Excel Ribbon, click the Data tab, and click Data Validation
  3. Click the Error Alert tab
  4. Remove the check mark from "Show error alert after invalid data is entered"
  5. Click OK to close the Data Validation box.


Obtained from the OzGrid Help Forum.

Solution provided by royUK.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:


How to find list of most frequent text in excel
How to add rows and specific text after changes in data
How to reference text in cell to unhide worksheet
How to use the CONCATENATE function to link text in two columns


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


stars (0 Reviews)