+ Reply to Thread
Results 1 to 3 of 3

VBA to generate random 5-digit serial numbers using

  1. #1
    Registered User
    Join Date
    12-14-2013
    Location
    edo,nigeria
    MS-Off Ver
    Excel 2007
    Posts
    85

    VBA to generate random 5-digit serial numbers using

    Hello. Good evening . I have a userform for keeping records and would love to incorporate a new feature. I would want to generate a random serial number for each entry made with the userform.
    The file is attached below. Click on the "Hire" button to show the userform.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: VBA to generate random 5-digit serial numbers using

    Try

    Please Login or Register  to view this content.
    Martin

  3. #3
    Registered User
    Join Date
    12-14-2013
    Location
    edo,nigeria
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: VBA to generate random 5-digit serial numbers using

    Thanks. Works like I wanted! More powers to your elbow!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 22
    Last Post: 06-27-2024, 10:35 AM
  2. [SOLVED] Formula to generate serial numbers needed
    By SLIDE1 in forum Excel General
    Replies: 2
    Last Post: 10-20-2012, 12:43 PM
  3. Need to generate a random serial number that automatically populates the transmittal sheet
    By chriscole412 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2012, 12:52 PM
  4. Need to generate unique serial numbers using algorithm
    By Alseikhan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2006, 03:50 AM
  5. [SOLVED] How do I generate a list of 5-digit numbers in Excel?
    By Cowboy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-29-2005, 11:05 AM

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