View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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.