drop down list sorted and selected by first lette

  • Thread starter Thread starter ROK
  • Start date Start date
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
 
For that, you have to use a ComboBox from the Control Toolbox toolbar
instead of Data Validation.
 
You must log in or register to reply here.

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

Data Validation List (conditional) 2
Pick from drop-down list gives empty or erroneous result 6
EXCEL DROP DOWN 2
Sorting of table depending on a drop-down-list entry 4
drop down list accessed by typing the first few letters 4
Drop Down lists 2
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Drop Down Lists 2

Back
Top