Private Sub TextBox1_Change()
'cod vba
Dim iii
'TextBox11 = Null
'TextBox82 = Null
Sheet1.Activate
iii = 2
Do Until Sheet1.Cells(iii, "b").Text = ""
If Me.TextBox1.Text = Sheet1.Cells(iii, "b").Text Then
Cells(iii, "b").Activate
Me.TextBox2 = ActiveCell.Offset(0, 1).Text
Me.TextBox3 = ActiveCell.Offset(0, 2).Text
'Exit Sub (à supprimer)
End If
iii = iii + 1
Loop
End Sub