Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RowSource | Excel Programming | |||
Rowsource referenced to a hidden workbook | Excel Programming | |||
listbox rowsource from wrong workbook | Excel Programming | |||
help with rowsource | Excel Programming | |||
Using IF, Then with rowsource? | Excel Programming |