Userform populating more than one worksheet

Hello Forum Members!

Once again, I'm in need of you expertise in solving a problem. I have a Userform that has a combobox to select one of the multiple sheets in the workbook, so that the information being entered into the form goes to that particular sheet. The problem is that the info is going to all the sheets in the workbook, which are the same in format just used at different times.
The user gets the form when a button is clicked. The form itself has a combobox with sheet choices and a few fields to enter information, then there is a submit button that is supposed to take the information to the selected sheet but instead is populating all the sheets in that workbook.
Is there a way to make the sheet selection also focus the delivery of the information collected to the selected sheet? In other words, if the user chooses sheet 3 from the drop down menu, fills in the fields with info, then clicks the submit button... what do I need to do to have that info appear only in sheet 3 and nowhere else?

Thank you in advance for any help you guys can provide on this one... and please let me know if you need more information.

Hi arlu1201 and everyone else,

Thanks for the interest on this issue! Here's the file in question... I'm still working on the first phase of development so there may be some missing components on the form, but I think there is enough data there to show you where the problem is:
Userform2 ("Shipping Info" button) allows the user to enter the data for the "heading" of the worksheet; only the data gets copied to all other sheets when the "submit" button is clicked. I would like the data to go to the selected worksheet only, which is designated by the combobox located on top of the form. Also, I may need the "submit" button on Userform1 ("Loader Sheet" button) to behave in a similar fashion... would the solution to the first issue work on the second?

Please let me know if there is anything else you may need... and thank you again for your help.

Hello Everyone...

Since I didn't hear from anyone on a possible solution to the problem, I kept playing around with the code until I found the right combination to make the userform work the way I needed it to. I'm posting the solution in case someone else needs to solve a similar issue.

Please Login or Register  to view this content.

Thanks for trying... and I hope this helps!