Private Sub ComboBox1_Change()
Dim i As Single, x As Long, z As Long, Calc As Long
Dim MyArray(20, 5)
ListBox1.ColumnCount = 5
x = 0
ligne = 0
DerLigne = Range("A65535").End(xlUp).Row
For i = 2 To DerLigne
If Cells(i, 1) = ComboBox1 Then
MyArray(ligne, 0) = Cells(i, 1)
MyArray(ligne, 1) = Cells(i, 3)
MyArray(ligne, 2) = Cells(i, 6)
MyArray(ligne, 3) = Cells(i, 8)
MyArray(ligne, 4) = Cells(i, 9)
ligne = ligne + 1
x = x + 1
Calc = Calc + Cells(i, 9)
End If
Next i
ListBox1.List() = MyArray
Label5.Caption = "Il y a... " & x & " lignes répertoriées dans la listBox1 !!!"
TextBox1 = Format(Calc, "### ### ##0.00")
End Sub