Can data validation also autocomplete?

V

Vato Loco

I want to know if you can have the entry cell autocomplete when it has
drop down bx. Is this possible?


Thanks, Vat
 
P

Peo Sjoblom

No..

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
B

Bernie Deitrick

Vato,

No, you can't. But if want to have the autocomplete feature and still have
data validation, what you can do is copy your data validation list to a
range above your entry area. This will enable autocompletion from your
validation list, though not at the same time, if you use the dropdown....

HTH,
Bernie
MS Excel MVP
 
Top