Userform Automatic Consecutive number?

Hi All

I'm stuck and don't know where I gone wrong?
I double check the code and can't see where I'm doing wrong?

At the minute click form?
No box: coming up blank where should be coming up 1?
Name box: Put name in then click add will come up to cell R17 But no number 1 in Cell Q17? Left it as a blank?
Now you see (No Box) come up 1? Put name in again in (Name Box) then click add go to R18 But number now go 1 in Q18
Next you see (No Box) now say 2.

If you click Exit, Then click Name button. (No Box) now blank where should be 2 to carry on?

Sample is I click Name button? (No Box: should be start as 1 (NOT BLANK)?
Also click Exit then click Name button go BLANK too?

Name go to Automatic in Alphabetically.

This code

Formula:

Please Login or Register  to view this content.

Regard

The procedure to initialize the userform is always called this...

Please Login or Register  to view this content.

It is not named after the userform name like you did here

Please Login or Register  to view this content.

Hi AlphaFrog

Thank you very much.

Now I understand what you explain to me!

Add Rep *

You're welcome. Thanks for the feedback.