Private Sub texb_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If texb.Name <> "Nouveau" Then Exit Sub
Dim Est As Range
With Feuil2
Set Est = .Range("A1:B" & .Cells(Rows.Count, 1).End(xlUp).Row).Find(texb, LookIn:=xlValues, lookat:=xlWhole, MatchCase:=True)
End With
If Est Is Nothing Then Exit Sub
MsgBox "Ce numéro est déjà dans la base !", vbCritical, "Code refusé :"
texb = ""
texb.SetFocus
End Sub