Private Sub TextBox1_Change()
Dim derlig&
Dim c As Range
derlig = Range("A" & Rows.Count).End(xlUp).Row
Set c = Range("A7:A" & derlig).Find(TextBox1.Value, , xlValues, xlWhole)
If c Is Nothing Then
TextBox2.Value = "Pas de résultat !"
Else
TextBox2.Value = Range("B" & c.Row).Value
End If
End Sub