Private Sub Txt_label_Change()
If Application.CountIf(Sheets("Articles").Range("joseph").Columns(1), Txt_label) = 0 Then
MsgBox "pas d'article", vbInformation + vbOKOnly, "client non"
Else
Txt_F1 = Format(Application.VLookup(Txt_label, Sheets("Articles").Range("joseph"), 7, 0), "0.00 €")
Txt_F2 = Format(Application.VLookup(Txt_label, Sheets("Articles").Range("joseph"), 8, 0), "0.00 €")
End If
End Sub