How to get entries into a list box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jill - 19 Jan 2006 19:35 GMT

H, I'm attempting a program to enter data into a list box and I'm having a
few problems, this is my first attempt t a VBA list box. Thank you for any
help you can offer Thanks Jill

Reply to this Message

Toppers - 19 Jan 2006 20:11 GMT

Jill,
Some of the ways to populate a listbox.

(Xl2003)

HTH

Private Sub UserForm_Initialize()

ListBox1.RowSource = "Sheet2!a1:a10"
'
' OR
'

ListBox1.RowSource = "MyList" ' <=== Named range
'
' OR
'
For j = 1 To 10
ListBox1.AddItem "aa" & j ' or could be range("b" & j) or similar
Next j

End Sub

> H, I'm attempting a program to enter data into a list box and I'm having a
> few problems, this is my first attempt t a VBA list box. Thank you for any
> help you can offer Thanks Jill

Reply to this Message