+ Reply to Thread
Results 1 to 5 of 5

VBA to Generate Unique ID

  1. #1
    Registered User
    Join Date
    10-06-2014
    Location
    Cincinnati
    MS-Off Ver
    2013
    Posts
    56

    VBA to Generate Unique ID

    Hi All,

    I'm trying to develop a vba script to generate a unique ID for all transactions submitted. I was searching online and I'm new to VBA so I was struggling to understand what was written. I was hoping someone could assist me.

    I have a form that will submit data onto a page called Data. On the sheet Data I want each transaction to timestamp an ID. If needed I could add the ID as a field on the Request Form sheet.


    Please Login or Register  to view this content.

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,034

    Re: VBA to Generate Unique ID

    Perhaps you should upload a sample file depicting a before and after scenario so that we can assist.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    10-06-2014
    Location
    Cincinnati
    MS-Off Ver
    2013
    Posts
    56

    Re: VBA to Generate Unique ID

    I just figured it out. I added a formula on the main page and then copied + pastevalues. Once I locked the formula it all worked.

  4. #4
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,034

    Re: VBA to Generate Unique ID

    Glad you got it working...

  5. #5
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,034

    Re: VBA to Generate Unique ID

    Why rep added...I didn't do anything...You found a solution to your problem lol..
    pls mark thread as solved...
    thanks

+ 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. [SOLVED] Generate Unique ID
    By hkbhansali in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-31-2018, 12:23 PM
  2. Generate Unique ID
    By N323100 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-26-2017, 05:44 AM
  3. [SOLVED] How to generate a unique ID
    By matrixpom in forum Excel General
    Replies: 9
    Last Post: 01-30-2015, 09:46 AM
  4. [SOLVED] Generate Unique list
    By Cavinaar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2013, 03:03 AM
  5. Generate unique number
    By adeleex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2011, 08:46 AM
  6. Generate Unique IDs
    By chinmayerram in forum Excel General
    Replies: 4
    Last Post: 04-13-2010, 08:10 PM
  7. Generate unique no automatically
    By ap_naveen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-24-2007, 06:48 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