Results 1 to 16 of 16

automatically generate / increment alphanumeric id in userform

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2018
    Location
    India
    MS-Off Ver
    2007, 2013
    Posts
    43

    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"
    Last edited by avijitsarkar; 03-09-2018 at 07:46 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-24-2018, 10:56 AM
  2. [SOLVED] Increment Alphanumeric List
    By frekels21 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-27-2017, 10:00 PM
  3. insert row and increment alphanumeric unique ID
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2016, 08:32 PM
  4. [SOLVED] Can't increment Alphanumeric string by one
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2016, 12:08 AM
  5. Replies: 7
    Last Post: 04-21-2015, 04:21 AM
  6. Replicate and increment alphanumeric keywords?
    By toolsavvy in forum Excel General
    Replies: 7
    Last Post: 12-16-2007, 03:02 AM
  7. Replies: 1
    Last Post: 07-11-2005, 07:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1