Thread: combo box from data validation with source list in separate sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default combo box from data validation with source list in separate sheet
There are instructions here for a combobox that uses a named range on a
different sheet:

http://www.contextures.com/xlDataVal11.html

Jay Trull wrote:
I am able to create a combo box for a data validation drop down list when the
source list is in the same sheet. I can't seem to get it to work on
workbooks where my source list is in a separate sheet? The combo box is
empty??


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote