Private Sub TextBox16_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim Rng As Range
If Not Me.Visible Then Exit Sub 'Userform fermé CloseMode 0 (X fenêtre)
If TextBox16.Text = "" Then Exit Sub
Set Rng = Sheets("Article").Range("C:C").Find(TextBox16.Text)
If Not Rng Is Nothing Then
MsgBox "Cee Nom Existant Déjà"
Cancel = True
End If
End Sub