Searching quicker within long dropdownlist

[Blackbird]

I am working on a document in which I want to have dropdown lists with (for
instance) countries. I know it is possible to for instance type "F" within an
existing dropdown list and go to "France " immediately or at least the first
country that starts with an "F". I can not seem to find the function that
turns this on. Right now, nothing happens and I have to scroll down very long
to find the correct country.

 

[Roger Govier]

Hi

If you are using Data Validation for your dropdowns, it does not have this
feature.
I have written some code to do this with DV, and an example file can be
found at
http://www.contextures.com/DataValHeadings.zip

If you want the ability to type parts of a name and have the list jump to
that point, you would need to use a Combo Box.
More information on this can be found here
http://www.contextures.com/xlDataVal14.html