Validation Lists?

  • Thread starter Thread starter war_amps
  • Start date Start date
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.
 
In the data validation dialog box, on the Error Alert tab, remove the
check mark from 'Show error alert after invalid data is entered'
 
Back
Top