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
.
.
.


   

    LastRow = Range("A65536").End(xlUp).Row
    
    
    Range("a" & LastRow + 1).Value = Range("A" & LastRow).Value + 1
    Range("b" & LastRow + 1).Value = Int(Now())
    Range("c" & LastRow + 1).Value = CSIPForm1.Workstream.Value
Any advide appreciated.

Neil