Autocomplete in data validation with separate workbook

T

tamee

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF does not show up in Autocomplete 4
Data Validation Link to Color Coating 1
Excel ActiveX Combo - AutoComplete and LIst Issues 2
Convert Local Names to Global Names 3
Claus code works on my data not on OP's data 2
Combo box 0
List of items from other sheets 2
Populate list or combo box from closed workbook 4

Top