bonjour Bouba
il y a quelques erreurs de synthaxe dans la macro
Do While ActiveWorkbook.
Sheets("Factures Fournisseurs").Range("B" & i) <> ""
ActiveWorkbook.Sheet
s("Factures Fournisseurs").Range("B" & i) = TextBox2.Value
je n'ai pas testé , mais tu peux aussi essayer cette adaptation :
Private Sub CommandButton4_Click()
Dim i As Integer
Dim j As Byte
For j = 2 To 6
If Me.Controls("TextBox" & j) = "" Then MsgBox "Veuiller Finir la saisie SVP ! ": Exit Sub
Next j
i = ActiveWorkbook.Sheets("Factures Fournisseurs").Range("D9").End(xlUp).Row + 1
With ActiveWorkbook.Sheets("Factures Fournisseurs")
.Range("B" & i) = TextBox2
.Range("C" & i) = TextBox3
.Range("E" & i) = TextBox4
.Range("F" & i) = TextBox5
.Range("G" & i) = TextBox6
End With
For j = 2 To 6
Me.Controls("TextBox" & j) = ""
Next j
End Sub
bon apres midi
MichelXld