Automatically generate alphanumeric user id when userform open in excel

01/05/1986 · Mar 2nd 2018

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.

**KjBox** · Mar 2nd 2018

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.

01/05/1986 · Mar 2nd 2018

This is a sample attachment

01/05/1986 · Mar 6th 2018

any one can help me plzzzz????

Automatically generate alphanumeric user id when userform open in excel

Participate now!

Share