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?

Check this out:
http://www.contextures.com/xlDataVal10.html


"pjk@boro" wrote:

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?

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

"JLatham" wrote:

Check this out:
http://www.contextures.com/xlDataVal10.html


"pjk@boro" wrote:

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?

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.

"pjk@boro" wrote:

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

"JLatham" wrote:

Check this out:
http://www.contextures.com/xlDataVal10.html


"pjk@boro" wrote:

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?