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!