JUMP TO PART OF A DROP DOWN LIST

G

Guest

When I have a long list, sorted alphabetically, can I set it so that, by
inputting the first letter, the selection jumps to the relevant part of the
list? If so, can this be expanded to two or more letters?
 
G

Guest

Thanks very much. I was hoping to use it with data validation, but thats not
possible. i'll give the combo box a try.
 
G

Guest

As noted at the site, Data Validation just doesn't give you that ability.
I've used the method she describes on that sheet successfully in one or two
projects myself. Took me a bit of 'trial and error' with her process until I
got the hang of it - it's not that her process of setting things up has
anything wrong with it, it was just that I wasn't really used to using
controls from the Controls Toolbox, usually using the ones from the Forms
toolbox, so there was a short learning curve in getting it set up properly
the first time for me.
 

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

How can I scroll within an alphabetical list in Excel? 1
Drop-Down List 3
Add Item to Data List that has Dynamic Source 1
Drop Down List Quicker Selection 4
letter recognition in drop down lists 1
Jump when copying a list of cells 3
Filtered drop down list 2
drop down list should remember selection. 6

Top