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.
Automatically generate alphanumeric user id when userform open in excel
- 01/05/1986
- Thread is marked as Resolved.
-
-
-
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.
-
This is a sample attachment
-
any one can help me plzzzz????
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!