How to create Serial Number using given digits for my userform

[badzxie14]

Good day I am not an IT expert but I am currently having a project of database on work. I am having trouble for the codes for my ADD COMMAND BUTTON of getting a serial number for 2 columns for the first column will retain the number and the second column will copy the digits of the first column then copy the above row with increasing (+)

For example in my ADD button if I click it I want it to function as follows

...to appear in worksheet .... ....in userform two text box first box will retain the 6-21- second box will show the next increment of given number which is 085287

A B C
Control No. Serial No. A (6-21-) Serial No. B (085287) > Add button clicked
1 6-21- 6-21-085288 >Add button clicked
2 6-21- 6-21-085289 >Add button clicked
3 6-21- 6-21-085290 >Add button clicked
4 6-21- 6-21-085291 >Add button clicked

 

[fadee2]

hy badzxie14,
Welcome to the board. I would suggest providing a sample file that would that would make it easier for everyone trying to help, to better understand and suggest solutions accordingly, rather then interpreting the query and making assumptions.