| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete in data validation with separate workbook
I have a data list of over 1,000 spare parts. I set it up with a master data
list in a separate workbook and data validation works fine. I need autocomplete so I tried inserting a combo box with VB and works fine if the data list is in the same workbook only. How can I make it work so that it refers to a separate workbook? Please help. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation and autocomplete -- again... | Excel Discussion (Misc queries) | |||
| Data Validation Combobox w/autocomplete | Excel Discussion (Misc queries) | |||
| Data validation: concatenate two separate ranges in the List? | Excel Discussion (Misc queries) | |||
| Data Validation from list on separate Workbook | Excel Discussion (Misc queries) | |||
| AutoComplete / Data Validation | Excel Worksheet Functions | |||
Threaded Mode
