Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Searching long data base list. | Excel Worksheet Functions | |||
DropdownList/AutoFillUpList | Excel Discussion (Misc queries) | |||
DropdownList/AutoFillUpList | Excel Discussion (Misc queries) | |||
searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
dropdownlist and linking help needed. | Excel Discussion (Misc queries) |