Dim k As Long
ListBox1.ColumnCount = 2
ListBox1.ColumnWidths = "50;80"
'remplissage de la ListBox en fonction de la ComboBox
With Sheets("donnees")
For Each Cel In .Range("A2:A" & .Range("A65536").End(xlUp).Row)
If CStr(Cel.Value) = CStr(cbxligne.Value) Then
Me.ListBox1.AddItem Cel.Offset(0, 1).Value
Me.ListBox1.Column(1, k) = Cel.Offset(0, 2).Value
k = k + 1
End If
Next Cel
End With