OK. So the nice columns I had turned into rows. Sorry.
"Tim Coddington" wrote in message
...
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?