Bonjour,
Tu rajoutes un ComboBox issu de la boîte à outils "Contrôles", et dans le code de la feuille, tu mets ceci :
Private Sub ComboBox1_Change()
Range("A1").AutoFilter Field:=4, Criteria1:="=*" & Me.ComboBox1 & "*"
End Sub
Private Sub ComboBox1_DropButtonClick()
Dim Cel As Range
Dim Tmp
Dim Mots_Cles As Object
Dim I As Byte
Set Mots_Cles = CreateObject("Scripting.Dictionary")
For Each Cel In Range("D2", [D65000].End(xlUp))
Tmp = Split(Cel.Value, ",")
For I = LBound(Tmp) To UBound(Tmp)
If Tmp(I) <> "" Then Mots_Cles(Trim(Tmp(I))) = Trim(Tmp(I))
Next I
Next Cel
Me.ComboBox1.List = Mots_Cles.Items
End Sub
Bonne soirée