Link sequential worksheet cell values to userform label

[pj2412]

Hi all!

Totally new to VB and have created a userform (attached) that when completed populates a worksheet. This works well but I'm having trouble linking the active serial number to the user form. I've managed to display a static value, but I need this to change when the next row is active?

Can anyone take a look?

Alternatively, is there a way for the userform to generate the serial number and add to the worksheet?

All help would be greatly appreciated!

Paul