Option Explicit
Dim DerLig As Long
Dim NB As String
Sub Bouton1_QuandClic()
NB = InputBox("Combien de shampoing coupe homme?")
If NB = "" Then Exit Sub
DerLig = Feuil1.Range("C" & Rows.Count).End(xlUp).Row + 1
If DerLig > 16 Then Exit Sub
Cells(DerLig, 2) = NB
Cells(DerLig, 3) = "shampoing coupe homme"
Cells(DerLig, 4) = "19" * NB
End Sub