Hi Y'all
I am having trouble adding items into a list box (from a spreadsheet). I can add a single item fine but I am stumped as to how i can have more columns. The List box is detailing a company car history of drivers - column 1 is name, 2 is start date, 3 is end date. This is what I have got so far:
For Each Cell In CarDriverHistorySource.Range("B:B"
If Cell.Text = Reg Then
HIr = Cell.Row
DriverHistoryLB.AddItem (CarDriverHistorySource.Cells(HIr, 4).Text)
End If
Next
column 4 is the driver name, 5 is start date and 6 is end date.
Answers on a postcard....
I am having trouble adding items into a list box (from a spreadsheet). I can add a single item fine but I am stumped as to how i can have more columns. The List box is detailing a company car history of drivers - column 1 is name, 2 is start date, 3 is end date. This is what I have got so far:
For Each Cell In CarDriverHistorySource.Range("B:B"
If Cell.Text = Reg Then
HIr = Cell.Row
DriverHistoryLB.AddItem (CarDriverHistorySource.Cells(HIr, 4).Text)
End If
Next
column 4 is the driver name, 5 is start date and 6 is end date.
Answers on a postcard....