Private Sub Lister()
Dim x As Integer
Dim DerLgn As Integer
With ActiveSheet
DerLgn = .Range("a" & Rows.Count).End(xlUp).Row
Bd = .Range("a2:h" & DerLgn).Value
End With
n = 0
For i = LBound(Bd) To UBound(Bd)
If Bd(i, 1) Like CbEleve & "*" Then
n = n + 1: ReDim Preserve Tbl(1 To UBound(Bd, 2), 1 To n)
For k = 1 To UBound(Bd, 2)
Tbl(k, n) = IIf(k = 7, Replace(Bd(i, k), ",", "."), Bd(i, k))
Next k
End If
Next i
ListBox1.Column = Tbl
End Sub