automatically generate / increment alphanumeric id in userform

please please solve this, i need it urgent

Just use Access, it does it automatically

but i need in excel.
any one have solution plzz???

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

friends.. this is a sample file that i want full fill..

thank u for reply, but where i pest the code? on textbox, userform activate or module..

thank yow, i think it will work for me, i tell u after checking the file
thankz again.

thank its worked, and i use the code in userform activate.
thanks again

Hello everyone just signed up here.
Need help in vba coding please.

i have 5 different Userform (i.e. Daily, weekly, monthly, 3monthly, 6 monthly schedule)
i have also separate data base for asset names, assets description, asset location, schedule of cleaning & cycles (daily, weekly, monthly...) records starts from A2,b2, c2 ....)
i need to filtered the database as per the schedule of cleaning (per day) and print each row in the userform as per their cycle.

attached data base for clarity.

appreciate any help, please

Lovelyangel

Good morning lovelyangel2

Welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.