I have a userform which I would like to transfer the data the several worksheets.

Hi

I have a userform which I would like to transfer the data the several worksheets.

However, I could not get the correct vba code, To enter data from a UserForm into two separate worksheets without opening Excel spreadsheets.

Please help me with the following:

1) I want to enter the data from the UserForm into two separate Excel files consisting of 4 columns in each of the two files, through the Input in UserForm textbox.

2) Neither Excel file should be opened.

There is a problem with all the codecs I've worked on, which is that after executing the command, one of the two files opens, which I don't want to happen.


Thank you.


With Regards
Waleed