Run Same User Form Again, Paste Values in Next Blank Row

Hi,

I have a userform in which when I click "save", the values I selected from the userform would paste in the column I specified.

What I am trying to do is that when I click another button (i.e. called "new service") on the same user form, the same user form would run again and after I select the necessary values on the 2nd user form, it would paste in another cell I specified (the next empty row)


The attachment is an example of what I want it to look like.
To explain the attachment more, if I click the "new service" button on my user form, the user form would pop up and I would enter "work" and the other necessary values. Once I click either "new service" again or "save", the values would paste in this case in "A10" since that is the first empty row (there are values up to C9 from the previous selection).

This is the code I have for pasting the values. "xRow=12" because I want my values to start pasting from row 12, column A from the first user form. Then what I want it to do is when the next user form(s) run, then to paste the values in the next empty row (not in row 12 column A).

Please Login or Register  to view this content.

If I can't do this, what do you recommend?

This would help a lot.

Thank you!!!

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)