Userform Exit button

[Guest]

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?

 

[Tom Ogilvy]

Use the QueryClose event.

 

[Ray Costanzo [MVP]]

Private Sub UserForm_Terminate()
Application.Quit
End Sub

Ray at work