Adding and incremental sequence to each new row

Hi all,

I'm still quite new so struggling with some syntx and knowing how things should work, so please bare with me. I have a very simple user form which when I submit the data to my sheet I want to include an incremental counter.


I have the below code which works fine, increments by 1 based on previous line. What I'd really line to have is the sequence vaulues to be prefixed with a string and the number value to be 5 digits.

i.e.
AWORD-00001
AWORD-00002
AWORD-00003
.
.
.

Please Login or Register  to view this content.

Any advide appreciated.

Neil

Not sure exactly where in your code it needs to go but I'm assuming:

Please Login or Register  to view this content.

You could change your code in:

Please Login or Register  to view this content.

Regards,
Antonio

Job done. Both gave me the output I needed. Respect to you both.


I'd like to say I was nearly there on my own...but I'd be a liar. I was way off.