Userform + close button

C

Chip Smith

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!
 
K

Kevin B

Just add the following to your code:

Unload Me
ActiveWorkbook.Save
Application.Quit
 
H

Harald Staff

Hi Chip

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

Best wishes Harald
 
Top