drop down list sorted and selected by first lette

R

ROK

I have setup a drop down list using Data validation. My challenge is to
select the items in the list by entering the first letter of the word in the
list. For example to choose Bear in the list I would enter "B" and it would
take me to the first entry with a "B".

Thanks in advance.

Richard
 
J

Juan Pablo González

For that, you have to use a ComboBox from the Control Toolbox toolbar
instead of Data Validation.
 
Top