Excel drop down box

  • Thread starter Thread starter nprice
  • Start date Start date
N

nprice

I have a drop down box in my file I use to look up
customers, I would like to know how and if I can use the
keyboard to jump to the customer by typing the frist
letters of their name, a
 
If this is a data validation dropdown, it doesn't support autocomplete.
If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html
 

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

Back
Top