Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox RowSource set to range of in-active sheet - possible?
I am trying to set a listbox RowSource to a range of cells on another,
in-active sheet. Is this possible? Using this give me the range of the active sheet : lstAddress.RowSource = "A4:E4" What needs to be added to make this reference another sheet? Thanks - Sean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox RowSource set to range of in-active sheet - possible?
I like to do it this way:
dim myRng as range .... set myrng = worksheets("sheet9999").range("a4:e4") .... lstAddress.rowsource = myrng.address(external:=true) Try msgbox myrng.address(external:=true) and you'll see what that does. What-A-Tool wrote: I am trying to set a listbox RowSource to a range of cells on another, in-active sheet. Is this possible? Using this give me the range of the active sheet : lstAddress.RowSource = "A4:E4" What needs to be added to make this reference another sheet? Thanks - Sean -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform Listbox using an active sheet | Excel Discussion (Misc queries) | |||
Listbox - Rowsource | Excel Programming | |||
range name as rowsource of listbox? | Excel Programming | |||
Listbox Rowsource Headings Multi columns Copy Range If Then Conditional | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |