السلام عليكم اخي سليم
مشكور على الاهتمام قمت بالطلاع على الكود لكن للأسف لم استطع تطبيقه على ملفي وفيما يلي الكود الذي لدي وارجو معالجته
Private Sub Bout1AF_Click()
If TextBoxAF48 = "" Or TextBoxAF49 = "" Or TextBoxAF50 = "" Or TextBoxAF51 = "" Or TextBoxAF52 = "" Or TextBoxAF53 = "" Then GoTo 1
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Fournisseurs")
iRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
ws.Cells(iRow, 1).Value = iRow - 8
ws.Cells(iRow, 2).Value = Me.TextBoxAF53.Value
ws.Cells(iRow, 3).Value = Me.TextBoxAF52.Value
ws.Cells(iRow, 4).Value = Me.TextBoxAF51.Value
ws.Cells(iRow, 5).Value = Me.TextBoxAF50.Value
ws.Cells(iRow, 6).Value = Me.TextBoxAF49.Value
ws.Cells(iRow, 7).Value = Me.TextBoxAF48.Value
Me.TextBoxAF53 = Empty
Me.TextBoxAF52 = Empty
Me.TextBoxAF51 = Empty
Me.TextBoxAF50 = Empty
Me.TextBoxAF49 = Empty
Me.TextBoxAF48 = Empty
Me.TextBoxAF53.Value = ""
Me.TextBoxAF52.Value = ""
Me.TextBoxAF51.Value = ""
Me.TextBoxAF50.Value = ""
Me.TextBoxAF49.Value = ""
Me.TextBoxAF48.Value = ""
Exit Sub
1
MsgBox "Il faut compléter les données", vbExclamation, "Erreur"
End Sub