Private ExécutionInduite As Boolean
Private Sub ComboBox1_Change(),If ExécutionInduite Then Exit Sub
With Sheets("CLIENT")
a = Application.Transpose(.Range("A2:A" & .[A65000].End(xlUp).Row).Value2)
End With
With ComboBox1
Range("C5").Value = .Text
ExécutionInduite = True
ComboBox1 = UCase(ComboBox1)
ExécutionInduite = False
If Len(.Text) = 0 Then
.List = a
.ListRows = Application.Min(10, .ListCount)
Else
fl = Filter(a, .Text, 2, 0)
Select Case UBound(fl)
Case -1: MsgBox "Il n'existe aucun client de ce nom !!!", vbInformation, "Information Recherche Client"
Case Else
.List = fl
.ListRows = Application.Min(10, .ListCount)
If UBound(fl) <> 0 Then .DropDown
End Select
End If
End With
End Sub