How to use a dropdown OR text option
Requirement:
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?
Solution:
Switch off the error alerts
- Select all the data validation cells where you want to allow other entries
- On the Excel Ribbon, click the Data tab, and click Data Validation
- Click the Error Alert tab
- Remove the check mark from "Show error alert after invalid data is entered"
- 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.
Gallery
