View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ray Costanzo [MVP] Ray Costanzo [MVP] is offline
external usenet poster
 
Posts: 22
Default Userform Exit button

Private Sub UserForm_Terminate()
Application.Quit
End Sub

Ray at work

"Luis" wrote in message
...
Hello.
I want to re-programme the X button on a userform to alter the

behaviour of
the button. I want to close the application instead of closing the

form.

How can i do this?