Thread: Autocomplete in data validation with separate workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tamee tamee is offline
external usenet poster
  
Posts: 5
Default 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!

Reply With QuoteReply With Quote