Duplicate UserForm pasted info

When I 'Submit' my userform it places the textbox entries onto a separate sheet in the first available row as intended.

What I also would like it to do is duplicate the entries if a specific field is filled out so it essentially fills in the first 2 available rows instead of just one.

What I have is a textbox named txtNew that when filled will assign a new serial number to the product identified in the form. I need to put in all the userform's info in one row under the original serial number and repeat right away with the new serial also. This is so that when searching for either serial number the user will be able to pull up record of the change.

Hi nohero

I'm unable to get a clear picture of what you have...I'd suspect others haven't either. Please post a workbook that demonstrates the issues and your desired outcome.

PLEASE include what code you currently have and illustrate this issue.

What I also would like it to do is duplicate the entries if a specific field is filled out so it essentially fills in the first 2 available rows instead of just one.

It's hard to answer without knowing what code that you use.

Something like this, you need to specify which sheet the code writes to

Please Login or Register  to view this content.

Sorry for not including more, here's a good portion of the code I use to submit the userform:

Please Login or Register  to view this content.

So, submitting this form creates a new row of info on the "ActionLog" sheet. What I want to add to this is some kind of IF statement that will create 2 new rows of info on the "ActionLog" sheet instead of just 1, both containing the same info except the 2nd one replacing txtSerial2 with txtNew in column A. This would only happen if cboAction = "Replace" though.

My code should work if you adapt it slightly

I can't test this, but give it a try

Please Login or Register  to view this content.