populate a listbox with values from rows in another worksheet

  • Thread starter Thread starter dovrox
  • Start date Start date
D

dovrox

How would I populate a list box with values from rows in anothe
worksheet
 
Hi Dovrox,
How would I populate a list box with values from rows in another
worksheet.
Click to expand...

Give the range with the values a name (insert, name, define) and use
that name as the listsource property.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
You'll have to use a named range. Select the range and
press Ctrl+F3 and give it a name like "mylist" (no quotes).
Then under Properties of the Listbox use mylist for the
ListFillRange.

HTH
Jason
Atlanta, GA
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Listbox 2 takes the value of Listbox 1 3
Populate row with work days 1
Create Drop Down Box populated by a List 1
Populating listbox with sheet names 1
Create an Invoice from a row of data 2
Populating data from a pull down 1
Loop through userform 2

Back
Top