Save and Close Button on an excel userfom

**Ruis** · 08-05-2010, 12:45 PM

Having a hard time figuring out how to write a script for a "save and close button" on my userform. I need it to save in a certain location once the “save and closed” button is clicked. I also need it to close out the userform and to close out of excel. Any help would be greatly appreciated.

**Richard Buttrey** · 08-05-2010, 01:00 PM

Hi,

Put the name of the location in a cell somewhere, use this as a variable and name the cell "SavePath". End it with a "\" e.g. C:\Temp\

Now attach the following macro to your form's save and close button

Please Login or Register  to view this content.

HTH

**Ruis** · 08-05-2010, 04:06 PM

Thank you Richard.......does it matter if i have multiable worksheets with in my excel userform?

**Richard Buttrey** · 08-05-2010, 05:01 PM

Hi,

I'm not sure what you mean by worksheets in a user form. Can you clarify please.

Rgds

**Ruis** · 08-05-2010, 06:09 PM

Sorry about not been clear.

I have 4 worksheet tabs within my excel spreadsheet. When the user opens the spreadsheet the userform is the only item they use to enter data (all the worksheets are hidden). I have the userform set to populate into worksheet tab (OrderLog). Once they have entered all the data the user clicks on "close form". Once they click on it I would like it to save (which I have working now) and close out of excel completely. Thanks again for your help. This site is VERY helpful.

**Richard Buttrey** · 08-05-2010, 06:27 PM

Hi,

To answer your original question, No it doesn't matter how many sheets you have. You are closing the whole Excel Application including the workbook you're using and any others that may happen to be open.

I don't think it's relevant but I don;t know what you mean when you say all worksheets are hidden. There is always at least one worksheet open in a workbook. Are you really meaning workbooks are hidden?

Regards

**Ruis** · 08-05-2010, 06:30 PM

Again sorry.....very new at VBA.
There is one workbook that is open that the user can see in the background. Its blank so that it looks clean to the user.