Private Sub CommandButton1_Click()
With Worksheets("Feuil1").[A1000000].End(xlUp).Offset(1)
.Value = Me.TextBox1.Value
.NumberFormat = String(15, "0")
End With
End Sub
Private Sub CommandButton2_Click()
Me.TextBox1.Text = Format(Worksheets("Feuil1").[A1000000].End(xlUp).Value, String(15, "0"))
End Sub