Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Speed Search in pick list by typing only first few letters
Is there any facility to pick from the list by typing only first few words (2
or 3) and the curser goes to the matched or nearby entry in the list arranged alphabetically ? This is similar to locating our topic in the Help index. In the pick list feature, I have to manually move the curser to the desire entry. If the list is long, it is not practicable to scroll down the list. -- Shrikant |
#2
|
|||
|
|||
A combobox from the control toolbox toolbar has this ability.
Shrikant wrote: Is there any facility to pick from the list by typing only first few words (2 or 3) and the curser goes to the matched or nearby entry in the list arranged alphabetically ? This is similar to locating our topic in the Help index. In the pick list feature, I have to manually move the curser to the desire entry. If the list is long, it is not practicable to scroll down the list. -- Shrikant -- Dave Peterson |
#3
|
|||
|
|||
Hi Shrikant,
Partial string lookups (#PartialString) http://www.mvps.org/dmcritchie/excel...#PartialString See posting http://groups.google.com/groups?thre...%40tkmsftngp10 the macro FindFirstChar in (finds first characters) http://www.mvps.org/dmcritchie/excel/code/proper.txt --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Shrikant" wrote in message ... Is there any facility to pick from the list by typing only first few words (2 or 3) and the curser goes to the matched or nearby entry in the list arranged alphabetically ? This is similar to locating our topic in the Help index. In the pick list feature, I have to manually move the curser to the desire entry. If the list is long, it is not practicable to scroll down the list. -- Shrikant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I search a mailing list spreadsheet to remove entries alre. | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Search list for new addition | Excel Worksheet Functions | |||
search with drop down list | Excel Worksheet Functions | |||
How do I create a "List If" function.I need to search a database . | Excel Worksheet Functions |