I think the combobox is looking for a string that has this format when the
source is in another workbook:

[book1.xls]sheet1!a1:a10

So your code should create that I think.

--
Jim
"TimK" wrote in message
...
I have a working application I'm trying to convert to an add-in. I have a
worksheet in the add-in workbook providing 160 named ranges of values used
to
populate the app's pull down menus. My problem is I can't find a way to
reference the named ranges within a new workbook using the Add-in. I make
reference to the named ranges in two ways. From the forms, I set the
Combobox2.RowSource to ='DataFields'!"$A2,$A23"; and within the code I set
object.RowSource = ThisWorkbook.Names!Priority . This works in the same
workbook, but I can't find a substitute way of setting the reference to
look
in the .xla based workbook since that is where the tables are. I've tried
x=workbooks("name.xla").worksheets("DataFields").n ames!Projects,
x=workbooks("name.xla").worksheets("DataFields").r ange("A2:A23"), ...
Nothing I've tried works.

Is there a way to do this?