Use this unique ID generator macro to insert into a textbox in a userform

Hello all,

I am very new to VBA scripting and excel. I thought that buying a big fat 1,100 page book on this stuff would help but i'm still stuck on a certain part. (SEE ATTACHED) Attached is the macro that will look at a column and find the highest number and create that number +1 for the uniqueID of that row. However, I want to be able to (on userform1_initialize), populate the textbox1 in the user form with the value that the macro comes up with (instead of it just populating the selected cell in the workbook.

This being because my userform that I am currently using (can't share because its got a bunch of confidential data sorry) will input all the info on the userform into multiple tabs in multiple places and I want each entry to have a unique ID that can be used as a reference value throughout the workbook.

Thanks for any help in advance

Can you explain this to me? I changed it a little for my current sheet but it still comes back with (1) each time.

Please Login or Register  to view this content.

I changed the .cells to reflect starting at row 3 in column a. However is it possible to take this following code:

Please Login or Register  to view this content.

(minus the msgbox part, i will be getting rid of that once I see the rest is working)
and reflect the c.value in userform1?
currently this is in a module. I'm assuming that's the best place for it, but if any of you pro coders know of a better placement, let me know.

Thanks!