Automatically generate alphanumeric user id when userform open in excel

A

avijitsarkar

New Member
Joined
Mar 1, 2018
Messages
8
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.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
So you have a UserForm. And when the UserForm opens you want.
The Textbox named "id" to be filled with:
"ICE/ANG/1002"
Then next time "ICE/ANG/1003"

Is this true?

How do we know what was the last id number?​
 
Last edited:
Upvote 0
I want say that my worksheet have some details and the last id no. is suppose "ICE/ANG/1002" , and when i open the userform , userform id textbox automatically fill a new id "ICE/ANG/1003"
 
Upvote 0
Yes I understand that.

Where on your sheet will I find this:
ICE/ANG/1002​
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
VBA Inventory UserForm ID generation
Replies
1
Views
708
Herakles
H
D
  • Question
excel userform problems after january 2023 security update?
Replies
0
Views
1K
donalde
D
A
  • Question
Automatically Hide Rows based on Formula driven Cell Value
Replies
1
Views
4K
mumps
mumps
N
  • Question
Opening userform closes excel and can't open other workbooks
Replies
3
Views
723
NHagedorn
N
J
  • Question
VBA Excel - customizing ribbonx issue - unhide tab when opening file with filename containing string
Replies
6
Views
1K
jdjehanneman
J

Forum statistics

Threads
1,215,036
Messages
6,122,796
Members
449,095
Latest member
m_smith_solihull

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top