ListBox

  • Thread starter Thread starter TOM
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ListBox RowSource Property 2
Set RowSource for ListBox 9
ListBox Remove Certain Text 6
inconsistent dir() behavior 1
ListFillRange 4
Listbox jump to value as you type 1
Listbox Problem 1
Listbox Column Display 3

Back
Top