Private Sub CommandButton3_Click()
Dim Recherche As Range
Dim rechercheadresse As String
If cmbnom = "" Then Exit Sub
With Sheets("base").Range("a:a")
Set Recherche = .Find(cmbnom, LookIn:=xlValues)
If Not Recherche Is Nothing Then
rechercheadresse = Recherche.Address
Do
resultat = resultat & vbNewLine & Recherche.Offset(0, 2) & Recherche.Offset(0, 3)
Set Recherche = .FindNext(Recherche)
Loop While Not Recherche Is Nothing And Not Recherche.Address = rechercheadresse
MsgBox resultat
Else: MsgBox "rien du tout"
End If
End With
End Sub