Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get entries into a list box
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get entries into a list box
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 "Jill" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reducing a List by Eliminating Entries from Another List | Excel Discussion (Misc queries) | |||
how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
make a list from another list ignoring duplicate entries from orig | Excel Worksheet Functions | |||
Removing all entries in one list that appear in a different list | Excel Discussion (Misc queries) | |||
Need to create unique list from list of multiple entries | Excel Programming |