Data Validation - Also allow items not in list

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
 
J

JulieD

Hi

on the error alert tab change from STOP to "warning" or "informtion"

Cheers
JulieD
 
B

Bernie Deitrick

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
 
D

Dave Peterson

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...
 
B

Bernie Deitrick

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
 
C

CyberSOG

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
 
Top