Option Compare Text
Private Sub Textbox1_Change() 'Recherche
Application.ScreenUpdating = False
Range("c2:c365").Interior.ColorIndex = 2
If TextBox1 <> "" Then
For ligne = 2 To 365
If Cells(ligne, 3) Like "*" & TextBox1 & "*" Then
Cells(ligne, 3).Interior.ColorIndex = 37
ActiveSheet.Range("C" & ligne).EntireRow.Hidden = False
Else
ActiveSheet.Range("C" & ligne).EntireRow.Hidden = True
End If
Next
End If
End Sub