multilistbox problem

[gibbo1715]

Hello all

I have been majorly impressed with how helpfull you all are so im gonna ask another question of you if i may

I have a dynamic range in a worksheet that starts at row 6, can i create a listbox on a userform that displays the contents of column b and column c with a title that is in row 5 ( Im using excel 2000)

Then if my user checkes the check box i ve attached to the list box (i.e Selects multi records) copy the row into another sheet when a button is pressed

Thanks again

Gibbo

 

[gibbo1715]

Figured out populating a multi list box using VBA

Private Sub UserForm_Initialize()

Dim cell As Range
Dim Rng As Range

With ThisWorkbook.Sheets("Sheet1")
Set Rng = .Range("A2", .Range("A2").End(xlDown))
End With

For Each cell In Rng.Cells
With Me.ListBox1
.AddItem cell.Value
.List(.ListCount - 1, 1) = cell.Offset(0, 1).Value
End With
Next cell

End Sub

Any help with the rest would be very appreciated