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?