Private Sub TextBox1_Change()
Dim x, tablo, ncol%, i&, j%, n&, a(), k%, b()
x = TextBox1.Text
tablo = [A1:M8000] 'matrice, plus rapide
ncol = UBound(tablo, 2)
For i = 1 To UBound(tablo)
For j = 1 To ncol
If tablo(i, j) Like x Then
n = n + 1
ReDim Preserve a(1 To ncol, 1 To n)
For k = 1 To ncol
a(k, n) = tablo(i, k)
Next k
Exit For
End If
Next j, i
If n = 0 Then ListBox1.Clear: GoTo 1
'---transposition---
ReDim b(1 To n, 1 To ncol)
For i = 1 To n
For j = 1 To ncol
b(i, j) = a(j, i)
Next j, i
'---restitution---
ListBox1.List = b
1 TextBox2 = n
End Sub