DV does that intrinsically.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sean" wrote in message
oups.com...
I have a Data Validation drop down, is it possible to prohibit the
user manually typing in a value other than those displayed within the
Drop down?


Thanks