create unique ID like a number or number letter combo for each new entry

rjmdc

Well-known Member
Joined
Apr 29, 2020
Messages
672
Office Version
  1. 365
Platform
  1. Windows
what vba would i use to add a unique transaction ID as soon as first column in the row is filled in. this id needs to be unchanging no matter what i do to this row
it also needs to stay static even if i sort or group.
please advise and help.
also this sheet already has many other vba so where would i add it
 
how can i upload my file to show whats not good?
 
Upvote 0

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
You'll need to select a CLOUD website such as www.DropBox.com or similar. Load your file there, then post a link here to that file for download.

Amazon offers a free cloud service as well.
 
Upvote 0
i am using your file the one you sent and trying it out
i enter in column A but nothing populates in column T
 
Upvote 0
EDITED by Moderator to remove abuse.

You should learn how to program in VBA yourself. Once you've done that FIRST ... and can be honest with yourself and others,
then perhaps come back to post legitimate programming questions.

I'll let the FORUM MODERATORS know about this.

Thank you for the opportunity to assist. Have a nice day.
 
Last edited by a moderator:
Upvote 0
thanks bad language is never allowed.
i am studying vba at his time. i have spent many hours in my studies. i care and wont give up.
somehow this is too difficult for me and i am not getting good guidance.
the code you sent i had found on danwagner except he also doesnt explain where to put the code in relationship to the rest of the code.
sorry that you are finding this difficult.it is obviously a run-around code since all over the web it all still returns to wagner
can you guide me where to put the code?
 
Upvote 0
If you are truly learning how to code, study the download file and see where THAT code has been placed, Then thing of how you
can apply it to your own workbook.

Being spoon fed everything will not help you learn how.
 
Upvote 0
@Logit
You have been around long enough to know that you should not insult members under any conditions. Please ensure that you NEVER do it again.
And for your information I am in total agreement with the OP, in that your code does not work, absolutely nothing happens.
So before slagging off members, please ensure that it is not your code at fault.
 
Upvote 0
For me it doesn't do anything that's visible.

Use of On Error Resume Next suppresses a Run time error '70' - Permission denied on line Set obj = CreateObject("Scriptlet.TypeLib")
and returns execution to Sub Test() where GUID is "" so I believe a null string is being written to column T.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

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