List Box RowSource

[bugcatchup]

I have a ListBox that works fine on the sheet my data is in. It shows 7 columns and 190 rows.

I want the form that contains the ListBox to open on another sheet. How do I reference the .RowSource property?

Now it uses .RowSource = ActiveSheet.Range ("D4:G63").

The other sheet is named "Formulas"...I tried using this.

.RowSource = 'Formulas'!("D4:G63") but it does not work.

Thanks for any help.

 

[Von Pookie]

Try:

.RowSource=Sheets("Formulas").Range("D4:G63")

 

[bugcatchup]

It still does not work. The form's ListBox shows the column headers for my "Formulas" sheet. But none of the info from my Main sheet where the range populates the Listbox.


Thanks for trying.