| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Navigate to an item in pulldown by typing first couple of letters
I have a list in sheet A and on sheet B I have a cell with a pull down
menu that lists the list from the sheet A. The list contains 2400+ items, and instead of scrolling down to the specific item, I am looking for a way to type the first couple of letters to get near the item I need to get. Is there anyway to get this done? Sheet B appears to be somewhat restricted such that recording or writing VBA is prohibited. Are there any functions or properties I can use to accomplish this? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list/typing item from list error | Excel Worksheet Functions | |||
| pre-fill cell by typing first few letters of a list | Excel Worksheet Functions | |||
| find item in drop down cell by typing the first few characters | Excel Discussion (Misc queries) | |||
| Make typing "jump" to matching item(s) in drop-down list? | Excel Discussion (Misc queries) | |||
| Speed Search in pick list by typing only first few letters | Excel Discussion (Misc queries) | |||
Threaded Mode
