Dim Sh As Worksheet, Lig As Integer
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim LaRecherche As String, Trouvé As Range
Set Sh = Sheets("feuil1")
LaRecherche = Me.TextBox1
On Error Resume Next
Set Trouvé = Sh.[A:A].Find(what:=LaRecherche, LookIn:=xlValues, LookAt:=xlWhole)
If Err = 0 Then
Lig = Trouvé.Row
Else
MsgBox "Pas trouvé"
End If
On Error GoTo 0
Me.TextBox2 = Sh.Cells(Lig, 2)
Me.TextBox4 = Sh.Cells(Lig, 3)
End Sub