Bonjour,
Remplacez votre code par celui-ci:
Option Compare Text
Private Sub TextBox1_Change()
Dim ligne As Integer, DerLig As Long
Dim Tableau As Range
Application.ScreenUpdating = False
Set Tableau = Range("Tableau1")
DerLig = Tableau.ListObject.ListRows.Count
For ligne = 6 To DerLig + 6
Range("C" & ligne).EntireRow.Hidden = False
If TextBox1.Value <> "" Then
Accent = Array("à", "â", "ä", "é", "è", "ê", "ë", "î", "ï", "ô", "ö", "ù", "û", "ü", "À")
SansAccent = Array("a", "a", "a", "e", "e", "e", "e", "i", "i", "o", "o", "u", "u", "u", "A")
Texte = Cells(ligne, 2)
For i = 0 To 14
Texte = Replace(Texte, Accent(i), SansAccent(i))
Next i
If Texte Like "*" & TextBox1.Value & "*" Then
Rows(ligne).Hidden = False
Else
Rows(ligne).Hidden = True
End If
End If
Next ligne
End Sub
Cdlt