automatically generate / increment alphanumeric id in userform

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.
that mean The last id number from automatically generate from the worksheet into the userform
please help me .
sorry for bad english.


this is my crospost link "www.mrexcel.com/forum/excel-questions/1045785-automatically-generate-alphanumeric-user-id-when-userform-open-excel.html"