Display Unique reference after userform is saved

[smone]

I have created a userform using vba in excel. The form works ok and pastes the detail directly into excel correctly. The spreadsheet is to record jobs raised within a production environment. I would like a msg box to apear when the record is saved containing a unique job reference number. Any ideas??

 

[SteveO59L]

Store your number in a cell, add a bit of code to increment it, then write it back to the cell