Listbox on a useform

I

ingleg

I am trying to add a listbox to a userform, but cannot work out how t
add a list to the listbox!

Any ideas?

Thanks in advance
 
C

Chip Pearson

If you want to fill the list with values from a worksheet range,
set the ListFill property to that range. Otherwise, use the
..AddItem method:

With UserForm1.ListBox1
.AddItem "a"
.AddItem "be"
.AddItem "c"
End With


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"ingleg" <[email protected]>
wrote in message
news:[email protected]...
 
B

Bob Phillips

You either add each item

With Listbox1
.Additem "Bob"
.AddItem "Jim"
'etc.

End With

or else you link it to a worksheet range, via the RowSource property.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
I

ingleg

Thanks Chip.

I tried the Row source previously, but must have mis-typed the cell
reference.
 

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

Access Using DAO.Database VBA code to populate a listbox from another listbox selection 1
Access Cannot select items in listbox 1
Creating a lookup in a userform 4
Add Listbox header using VBA 1
Drag and Drop from List to Tree View 1
Subscript Text in Listbox 1
ListBox Click Event 6
Easy Question 3

Top