Private Sub TextBox1_Change()
Dim Ligne&, Colonne&
Application.ScreenUpdating = False
Range("B2:B25,D2:D25,F2:F25").Interior.ColorIndex = 2
ListBox1.Clear
If TextBox1 <> "" Then
For Ligne = 2 To 25
For Colonne = 2 To 6 Step 2
If Cells(Ligne, Colonne) Like "*" & TextBox1 & "*" Then
Cells(Ligne, Colonne).Interior.ColorIndex = 43
ListBox1.AddItem Cells(Ligne, Colonne)
End If
Next
Next
End If
End Sub