Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Complete a select from a data validation list
I am using a list of 5,000 items stored on a separate worksheet in the same
work book for data validation of the items being selected on my order form. The data validation feature seems to be working ok, when you select the down-arrow, the list appears. However, with 5,000 potential selections, scrolling to your choice is too time consuming. Can I make this list work more like a combo box, so the user can time the first few letters, and the list will search for matching items? -- Thanks so much Lele |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto complete in a validation list | Excel Discussion (Misc queries) | |||
Using a 'Select' (Data Validation) List? | Excel Worksheet Functions | |||
data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
How to dynamically select a validation list from data in a cell? | Excel Discussion (Misc queries) | |||
Auto scroll down data validation list | Excel Discussion (Misc queries) |