Hi all,

I am looking for some VBA help. I need code to auto-generate a "ProjectID".

Here's how it should work:

on my userform I have 3 radial buttons

"East"
"West"
"South"

Depending on which you select the "ProjectID" text box will auto-generate this alphanumeric value. An example:

"East" was selected

The number generated is: 13E00001

13 - the year the entry was made
E - For East
00001 - 5 digit code that is sequential (so if I were to repeat the process the next number generated would be "00002")

Any help you can offer would be greatly appreciated. I've been having a hard time finding resources for this type of code work and I am not fluent in VBA.

Thanks,

Wolfman