Populate the next row value to be the last row +1

[clapforthewolfman]

Hi all looking for some VBA help.

So I have designed a userform that will autogenerate a ProjectID code:

Please Login or Register  to view this content.

What I want to happen next is after the user inputs the data from the UserForm (clicks the "OK" button) a command will run that takes the last value in either column D E or F of the "ProjectID Values" page and adds 1 to it and inserts this value into the next row. That way when a user opens this form again the ProjectID will be the next in a sequence.

Here is what I have so far but I know that it is wrong:

Please Login or Register  to view this content.

Any help you can offer would be greatly appreciated!!

Wolfman

[clapforthewolfman]

It could maybe look something like this?

Please Login or Register  to view this content.

[clapforthewolfman]

Don't you love it when you solve your own problems!!

Please Login or Register  to view this content.