I’m doing an inventory userform. I need to create an automatic code for each item that is registered. Say, Item 1 – P0001, Item 2 – P0002, and so on. I’ve tried adding a string “P” to the number, but it won’t work.
How can I do this?

My userform, I need the automatic code to appear in the dark gray textbox

I tried adding the “P” to a list of 0001 + 1, but it didn’t work