Urgent solutions needed to resolve vba coding

Hi, I met with some vba coding problem with my project. Pls help me if you can resolve it. Thank you!

1. I need to run userform in one workbook and the data must be transfered to another workbook's sheet. How do I do it?
2. My file is 3MB and it runs really slow in automatic mode but I need the automatic mode to update all my data. So how can I reduce the loading and calculating time?
3. How can I automatically close my userform after clicking on the msgbox that pop up?
4. Is it possible not to activate the userform at the sheet that it is going to input data?

1. It's possible, yes. You just have to specify the whole lot, e.g.

Workbooks("My Book").Sheets("The Sheet").Range(MyRange).Value =
MyForm.Textbox1.Text

or similar.

2. Not sure - can you be more specific about what/how is
loading/calculating

3. Just insert:

NameOfUserform.Hide

at the point you want it to vanish. You mention a msgbox, so I guess
the outcome of the msgbox will determine where you put this code.

4. Don't understand the question - if you mean can it appear whilst
using different sheets, then yes.

Thank you, JakeyC.

1. Every time i open my workbook, excel has to spend at least 5 minutes calculating all the cells before I can use the program. And most of the time, the calculation cause the whole excel to hang. I have many IF functions imbeded in the worksheet to simulate auto calculation, recorded macros to auto the updating of information and a userform to let the user key in data to check the availability of the timings (It is a restaurant booking system.)

2. I have a button in Sheet 1 to activate the userform and the data collected from the userform will be transferred to Sheet 2. Every time I confirm the userform, the userform will bring me to the Sheet 2. But I want the userform to remain in Sheet 1 as backdrop. Can I use any codes to do do that?

1. If you have a macro that runs at startup, or causes delays during
use, place the statement,
Application.ScreenUpdating = False at the start, then
Application.ScreenUpdating = True at the end

This will speed things up a bit.

Recorded macros can be very inefficient, so maybe look and see if it's
doing anything unnecessary.

To end up at sheet1 after using sheet2 with the macro, just place:

Sheets("Sheet1").Activate

at the end of the procedure