sequence in a macro text box

[kelvin_9]

Hello all, I was thinking is this possible to automatic generate a new number under a text box in macro when I open up the userform with my request:
1) starting with 1906-001, 1906-002, 1906-003... and so on
2) I wish the number showing in textbox2 and textbox2 is default on column C
3) after finished, go back to column A and next new row for next entry automatic

I tried this thread but I can't change successfully on my request #1
https://www.mrexcel.com/forum/excel...ode-auto-generate-next-sequential-number.html

Thank you all your great help
kelvin

 

[kelvin_9]

any solution please?