Data Validation - Also allow items not in list

  • Thread starter Thread starter CyberSOG
  • Start date Start date
C

CyberSOG

I want to use data validation to allow users to select the most common
answers in a drop-down menu, but I also want them to be able to type in
others that are not listed. I am sure the solution is easy I just can't
seem to find in on the boards.

Thanks,

Jesse
 
Jesse,

Data Validation can't be made to work that way on a single cell. If you use
three cells, then you could use a formula in the third cell that was along
the lines of

=If(A1<>"",A1,B1)

A1 would use the data validation, B1 would be free entry, and C1 would have
the formula.

You could write VBA code that would do exactly what you want - give a list
or allow free entry, but that isn't 'easy'

HTH,
Bernie
MS Excel MVP
 
Or even choose not to warn them.
I want to use data validation to allow users to select the most common
answers in a drop-down menu, but I also want them to be able to type in
others that are not listed. I am sure the solution is easy I just can't
seem to find in on the boards.

Thanks,

Jesse
Click to expand...
 
Jesse,

rse, after I posted this, I simply cleared the check box next to "Show error
alert after invalid data is entered" on the Alert tab, and Data Validation
works exactly the way you want when that is done Another day, another lesson
in Excel....

HTH,
Bernie
MS Excel MVP
 
Thanks all. I knew there had to be easy way, but just couldn't find it.
There always is a hard way too.

Peace,

Jesse
 
Back
Top