Hi Tara

choose data / validation
choose list
set the source
and UNTICK in cell drop down

Cheers
JulieD

"Tara Keane" wrote in message
...
Is it possible to set up validation so that it only accepts as valid the
entries in a list somewhere (Job codes) but I don't want a pick list. I
just
want it to reject as invalid any code entered that is not in my list of
job
codes