Adding a sequential number to worksheet via user form and vba

[Paul15]

Hi. I have a worksheet with data being entered via a user form. This uses a command button ( submit button) to submit data to sheet. I wish to have a sequential number added to each new row of data; my sheet this will be at column AS of whatever row the new data is copied to upon activation of the command / submit button.
The number must increment by 1 for each new row from a predetermined start value, say 120000.
The number must remain sequential no matter if the form is closed or cleared before submission, last number, eg 120010, form cleared or closed, reopened next number 120011
All data should write to the sheet at the same time and all be on the same row

Regards

 

[Fluff]

Duplicate Sequential number generation

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).