ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform Exit button (https://www.excelbanter.com/excel-programming/319826-userform-exit-button.html)

Luis

Userform Exit button
 
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

Userform Exit button
 
Use the QueryClose event.

--
Regards
Tom Ogilvy

"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?




Ray Costanzo [MVP]

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?





All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com