The form needs an invoice number.

[Matt5353]

I have a form that when it is printed the first one is 001, 002, 003 up to 500. My active cell will be A1. Is there a way to add a different number every time I print.
Andrew

 

[DanteAmor]

Hi @Matt5353

Run the following macro every time you want to print, it will automatically increase the cell value by 1 and then print the sheet.

Sub printsheet()
  Range("A1").Value = Format(Range("A1").Value + 1, "'000")
  ActiveSheet.PrintOut
End Sub