Userform + close button

i have a user form and when you click the "Close" button at the bottom it
closes out of the macro/userform it looks like this right now..

Private Sub cmdClose2_Click()
Unload Me
End Sub

what can i add to this sub so that when the button is clicked it

1. saves the workbook
2. closes the worksheet/exit out of excel

thanks!

--
--Chip Smith--

Just add the following to your code:

Unload Me
ActiveWorkbook.Save
Application.Quit

--
Kevin Backmann


"Chip Smith" wrote:

> i have a user form and when you click the "Close" button at the bottom it
> closes out of the macro/userform it looks like this right now..
>
> Private Sub cmdClose2_Click()
> Unload Me
> End Sub
>
> what can i add to this sub so that when the button is clicked it
>
> 1. saves the workbook
> 2. closes the worksheet/exit out of excel
>
> thanks!
>
> --
> --Chip Smith--
>

Hi Chip

What happens if the user has more than your file open in Excel ? Don't do
that.

Best wishes Harald

"Chip Smith" <ChipSmith@discussions.microsoft.com> skrev i melding
news:99F84912-8FC1-446B-B0FA-C456E319EDA6@microsoft.com...
> i have a user form and when you click the "Close" button at the bottom it
> closes out of the macro/userform it looks like this right now..
>
> Private Sub cmdClose2_Click()
> Unload Me
> End Sub
>
> what can i add to this sub so that when the button is clicked it
>
> 1. saves the workbook
> 2. closes the worksheet/exit out of excel
>
> thanks!
>
> --
> --Chip Smith--
>