pcsparky
01-22-2009, 11:18 PM
I know that I want a 2 column Listbox to display a list of handlers and their dogs.
I have been trying to understand the concept of populating such a Listbox but after a few hours of research on the net I'm stumped.
I've managed to get this so far:
With ListBox1
.ColumnCount = 2
.ColumnHeads = False
.AddItem [handlerName]
.List(0, 1) = [dogName]
End With
The loop that I have populates the left column fine but the right column only shows the last dog's name in the data list (at the top of the listbox).
Obviously I'd like to get help on getting this to work but if anyone can explain this better than what I've read so far I'd be very grateful.
I have been trying to understand the concept of populating such a Listbox but after a few hours of research on the net I'm stumped.
I've managed to get this so far:
With ListBox1
.ColumnCount = 2
.ColumnHeads = False
.AddItem [handlerName]
.List(0, 1) = [dogName]
End With
The loop that I have populates the left column fine but the right column only shows the last dog's name in the data list (at the top of the listbox).
Obviously I'd like to get help on getting this to work but if anyone can explain this better than what I've read so far I'd be very grateful.