List Box Row Source

  • Thread starter Thread starter jhahes
  • Start date Start date
J

jhahes

Can someone please help me with a code that puts

the row source of the list box to the activecell


listbox1.rowsource =
 
listbox1.rowsource = Worksheets("Sheet1").Range("A1:A10").Address(,,,True)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
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

Code seems limited by row number 1
ListBox Remove Certain Text 6
what is the code cann make this pls. help me 1
Populating a ListBox with an Array 1
list box remove item by combobox 4
ComboBox and rowsource from an external sheet 5
How do I insert a Filter range result into a ListBox 4
Inserting Data from another sheet based on Listbox Selection 2

Back
Top