Autonumber within VBA Userform, not via formula

[Orestees]

I'm really looking for an autonumber method that works within a userform rather than using a formula on a sheet where the data would go. Someone helped me with the formula version but for the users purposes, the autonumber must be userform driven. Since none of it is dependent upon my code, I haven't posted any but let me know if it is indeed needed.

Any ideas?

Thanks in advance for any help. My last post died so I'm trying to break up the issues I had into seperate posts.

[mike7952]

if the range will have only A number you can get the max number and add 1 to it

Please Login or Register  to view this content.

[Orestees]

Where should this code be placed to work? I tried in creating a hidden TextBox and used the code there, but I'm sure I'm wrong. Also tried within the Finalize Sub to no avail.

Sorry, I'm a beginner at code in general. Thanks again for the help!

[cplmckenzie]

Without actually seeing your sheet, I would say the code example given by mike7952 would go in the userform open event.

Maybe post your sheet?

cplmckenzie

[Orestees]

Example Autonumber (Broken).xlsm

I tried in the initialize event but nothing changed. I've attached the example I'm using and really appreciate the help. This project is almost done so these little pieces matter more at this point.

Thanks again in advance!

[mike7952]

I would put it into your Finalize_Click() Event

Please Login or Register  to view this content.

[Orestees]

I tried adding the code in but nothing changed. I also tried again with adding numbers for the prior entries but that didn't help either.

Thanks for sticking with me here.

[mike7952]

This works for me

Example Autonumber (Fixed).xlsm

[Orestees]

Thanks a ton Mike, that works perfectly!! This is a huge help.

I really appreciate your patience with me!

Cheers

[mike7952]

Your welcome