Private Sub ComboBox1_Change()
Dim i As Integer
test = 0
For i = 6 To Range("F65535").End(xlUp).Row
If UCase(Left(Cells(i, 6), 1)) = ComboBox1.Text Then
'MsgBox ("Résultat trouvé: " & vbLf & Cells(i, 6) & vbLf & "en ligne " & i)
Rows(i).Select
test = 1
Exit For
End If
Next i
' If test = 0 Then MsgBox ("AUCUN RESULTAT")
End Sub