DATA / VALIDATION / List

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

Jim Thomlinson

Go to the Error Alert tab in the validation dialog and uncheck the "Show
error alert.." Check box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Validation list in data entry form 4
Data Validation 3
Data validation list using filtered range 3
Data Validation - List of unique values 2
data - validation - list question 2
Customise drop down list validation 3
Drop down list 2

Top