Rowsource from another workbook
 

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

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

Rowsource from another workbook
 

How do I do this when the range for the rowsource is named? The name I am
using is 'wrkshtrng'.
"JLGWhiz" wrote:

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

Rowsource from another workbook
 

I like to let Excel create it for me.

Dim rng as Range, RowSrc as String
Set rng =
Workbooks("SomeBook.xls").Worksheets("SomeSheet"). Range("ListRange")
RowSrc = rng.address(External:=True)

or if it's a book-level range name

Dim rng as Range, RowSrc as String
Set rng = Workbooks("SomeBook.xls").Names("ListRange").Refer sToRange
RowSrc = rng.Address(External:=True)


--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility
Now with Table Compare for quick table comparisons


"ranswrt" wrote in message
...
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

Rowsource from another workbook
 

That worked great Thank You

"Tim Zych" wrote:

I like to let Excel create it for me.

Dim rng as Range, RowSrc as String
Set rng =
Workbooks("SomeBook.xls").Worksheets("SomeSheet"). Range("ListRange")
RowSrc = rng.address(External:=True)

or if it's a book-level range name

Dim rng as Range, RowSrc as String
Set rng = Workbooks("SomeBook.xls").Names("ListRange").Refer sToRange
RowSrc = rng.Address(External:=True)


--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility
Now with Table Compare for quick table comparisons


"ranswrt" wrote in message
...
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