I'd try:

lbPAAccount.RowSource _
= wb.Names("AccountAbbrev").RefersToRange.address(ex ternal:=true)



cellist wrote:

I'm trying to set the rowsource for a listbox to use a named range in a
workbook that's external to the workbook where the listbox is defined.

Dim wb As Workbook
Set wb = Workbooks("Budget Account Table.xls")
lbPAAccount.RowSource = wb.Names("AccountAbbrev").RefersTo

The "Budget Account Table.xls" is open in the current workspace. Do I also
need to
Activate "Budget Account Table.xls"?

--

Dave Peterson