View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
What-A-Tool What-A-Tool is offline
external usenet poster
 
Posts: 14
Default 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