DATA / VALIDATION / List

  • Thread starter Thread starter DKS
  • Start date Start date
D

DKS

Hi,

I want to apply data validation to a column wherein I would prefer to have a
drop-down of certain preferred values. But I would also like to leave the
option for the user to enter any other value (thus not force the user to
select something from the drop-down list).

Is there a way to achieve this?

Many thanks in anticipation.
 
Go to the Error Alert tab in the validation dialog and uncheck the "Show
error alert.." Check box.
 
Back
Top