Hi everyone. I'm new here and I hope you guys can help me out and solve my problem.

I want to create a ID number with 2 letters in front, see my attachment.

For example;

In the userform "Input Details" ID= (OF-90001)

I try to fix this also for the userform "Info Details" and in the Sheet1 at column A.
I get only the numbers and not the letters in front of it.

Please somebody have the solution.

Thanks Ray Test1a (Ray).xlsm