| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autocompletion of cell input based on databse list
I have a list of about 25,000 cities in an excel file with other info like
zip codes, etc. I want to START to type in the name of the city and have the cell begin to autofill based on matching letters I have typed. My Intuit QuickBooks works the same way. Or have a dropdown list of cities with matching characters so I can complete the search. Then lookup the other data corresponding to that city. I can also reduce the size of the search by using a state filter and or the entire list can be sorted alphabetically. How would I go about setting up this up? Is there such a autocompletion function as I type in a single cell? Thanks in advance Pal |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autocompletion of cell input based on databse list
Only a combobox/Listbox from the control toolbar toolbox offers this
functionality. There really isn't any straightforward way to mimic this functionality in a cell beyond the built in pick from list, but this works with data in the same column. -- Regards, Tom Ogilvy "Pal" wrote in message news:CAy%b.27275$AL.495251@attbi_s03... I have a list of about 25,000 cities in an excel file with other info like zip codes, etc. I want to START to type in the name of the city and have the cell begin to autofill based on matching letters I have typed. My Intuit QuickBooks works the same way. Or have a dropdown list of cities with matching characters so I can complete the search. Then lookup the other data corresponding to that city. I can also reduce the size of the search by using a state filter and or the entire list can be sorted alphabetically. How would I go about setting up this up? Is there such a autocompletion function as I type in a single cell? Thanks in advance Pal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill cell colour based on input in another cell | Excel Worksheet Functions | |||
| How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
| run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
| Averaging values from a list, based on user input | Excel Worksheet Functions | |||
| Data input based on date list? | Excel Worksheet Functions | |||
Linear Mode
