ListBox RowSource set to range of in-active sheet - possible?

[What-A-Tool]

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]

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.