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
Obtained from the OzGrid Help Forum.
Solution provided by royUK.
|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