Excel - As you type drop down select?

[akrshaw]

So, when I start typing a choice in the drop down cell it does not show me possibilities?

Can I do something where when I type "wes" it will automatically show me "western"?

If do I have to scroll down each list to find it?

I am probably not calling it what it is supposed too...?

Thanks!~

 

[Andrzejek]

You may get a better chance of getting the answer if you provide some more information, like:
Is that Drop-Down combo on the UserForm or on the sheet?
The Style property of it?
How do you populate it?

Have fun.

---- Andy