Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ok. Figured out how to load a list box
from an Excel range, like so ... Private Sub UserForm_Initialize() ListBox1.ColumnCount = 4 ListBox1.RowSource = "A2:D" & Cells(1, 1).End(xlDown).Row End Sub Sample of spreadsheet values follows: Name, First Name, Last Class Address Amber Boger 2 Shane Bobber 1 Sean Cantral 1 Bobby Smith 3 Lucy Johnson 1 Linn Cenad 2 Now I need to load ListBox1 from the same range, but only data from a certain class, say 2. The list box would pick up Amber and Linn, but not Sean (because he is class 1). Is there a way to do that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a listbox to show every unique record in a range | Excel Worksheet Functions | |||
Q: find range, listbox - format and fit columns | Excel Programming | |||
listbox not dsplaying all records in a named range | Excel Programming | |||
ComboBox Population of Cell Range | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |