| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
