ListBox

T

TOM

Hello,

I want set RowSource for ListBox in another worksheet then is my Forms. How
can I do it?
For same worksheet is like this: Sheet1!A2:C12

Thanks Tom
 
T

Tom Ogilvy

Private Sub Userform_Initialize()
Listbox1.RowSource = Worksheets("Book2.xls"). _
Worksheets("Sheet1").Range("A1:A100").Address(external:=True)
End sub

Assuming the other workbook is open.
 
Top