Autocomplete in data validation with separate workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
This sounds like an Excel question. If this is a .Net question, post your
code. If this is an Excel Programming question, please find a group with
"Excel" and "programming" in the title. This is a .Net Programming
newsgroup.

Robin S.
 
Back
Top