advancing invoice numbers

[griff888]

I have created an invoice on excel and would like to put a button on the page which will advance the invoice numbers when clicked.
for example I am currently wring up an invoice which is number 10045 when this invoice is completed I would like to be able to just click a button and the invoice number would move forward to 10046 (using the same spreadsheet)

 

[VoG]

Try like this with a button from the Controls toolbar

Private Sub CommandButton1_Click()
Range("A1").Value = Range("A1").Value + 1
End Sub

 

[griff888]

Thanks for the help salty it works a treat