View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Rowsource from another workbook

Maybe:
[OtherWorkbook.xls]Sheet1!a1:f25

Or if the wb name is two or more words:

'[Other Workbook.xls]Sheet1'!a1:f25

"ranswrt" wrote:

I have a workbook that I am using to create estimates on. I have another
workbook that contains the databases for the estimates. How do I set a
listbox rowsource from different workbook than the form with the listbox is
in?
Thanks