Option Explicit Private Sub CommandButton1_Click() Dim obj As Object Dim FL1 As Worksheet Dim DerniereLigneUtilisee As Long DerniereLigneUtilisee = Range("A" & Rows.Count).End(xlUp).Row + 1 'adapter colonne Set FL1 = Worksheets("Feuil1") 'adapter feuille With FL1 Set obj = .Columns("A").Find(TextBox1.Text, , , xlWhole) 'adapter colonne If Not obj Is Nothing Then MsgBox "Cet article existe déjà!", vbCritical, "Ajout d'article": Exit Sub Range("A" & DerniereLigneUtilisee).Value = TextBox1.Text ' ajout d'article End With End Sub
Option Explicit Private Sub CommandButton1_Click() Dim obj As Object Dim FL1 As Worksheet Dim DerniereLigneUtilisee As Long Dim DerLigne As Long DerniereLigneUtilisee = Range("A" & Rows.Count).End(xlUp).Row + 1 'adapter colonne DerLigne = Range("L" & Rows.Count).End(xlUp).Row + 1 'adapter colonne Set FL1 = Worksheets("Feuil1") 'adapter feuille With FL1 Set obj = .Columns("A").Find(TextBox1.Text, , , xlWhole) 'adapter colonne If Not obj Is Nothing Then MsgBox "Cet article existe déjà!", vbCritical, "Ajout d'article": Exit Sub .Range("A" & DerniereLigneUtilisee).Value = TextBox1.Text ' ajout d'article Set obj = .Columns("L").Find(TextBox2.Text, , , xlWhole) 'adapter colonne If Not obj Is Nothing Then MsgBox "Ce magasin existe déjà!", vbCritical, "Ajout de magasin": Exit Sub .Range("L" & DerLigne).Value = TextBox2.Text ' ajout de magasin End With End Sub