Automatically generate alphanumeric user id when userform open in excel

  • hii friends, I'm new in excel vba,i just want to make a student database in excel userform, and there is a column student id, which is the alphanumeric serial like "ICE/ANG/1001".every time when i open the userform to enter a new student database the id text box goes to auto fillup or generate with last alphanumeric id like " ICE/ANG/1002" and "ICE/ANG/1003" and "ICE/ANG/1004" to be continue.
    please help me .
    sorry for bad english.

  • Welcome to Ozgrid!


    Please can you attach your workbook.


    Click the paperclip icon on the right of the top icon bar in Reply Box, then click Upload File which will appear on bottom menu bar. Browse to required file in the dialog that pops up and double click that file.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.