Searching quicker within long dropdownlist
 

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.

Searching quicker within long dropdownlist
 

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

--
Regards
Roger Govier

"Blackbird" wrote in message
...
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.