Validation Lists?

W

war_amps

I have made a drop down using the List in Validation with two options,
say X and Y. 95% of the time either X or Y will be chosen but I would
like to give the user the option to type into the same cell any value,
not necessarily X or Y. I could take out the Validation and let the
user input as a regular cell but I would like to keep the X,Y dropdown
if possible.

Any way to do this?

Thanks.
 
D

Debra Dalgleish

In the data validation dialog box, on the Error Alert tab, remove the
check mark from 'Show error alert after invalid data is entered'
 
Top