List Box refer to an array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I need to create a listbox1 within a userform to select one name from a list
of names.

The list of names varies in length from 3 to 60 people.

The list of names starts at B2 and goes down (and varies in number)

Can I get it to default to the 'users' name (from Tools>Options...>General)?

Do I have to set up a dynamic 1d array when I call up the userform?

Kind regards
 
UserForm1.ListBox1.RowSource = "B2:B" & _
Range("B2").End(xlDown).Row

HTH
Jason
Atlanta, GA
 

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

List box Setup from Varying 1d Array 1
Userform List box to Text Box 1
VLOOKUP variable array references 1
Creating a lookup in a userform 4
Using Named Range within an Array Formula 2
How to Reference an Array to Count Values? 6
Matching 2 list of data array, and return it as True if matched 1
list box 2

Back
Top