View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cellist cellist is offline
external usenet poster
 
Posts: 24
Default listbox getting error 380 cannot set the rowsource property

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"?