| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get userform Cancel button to invoke Exit Sub in calling macro? | New Users to Excel | |||
| how do i make a button from a userform exit onto the document in . | New Users to Excel | |||
| Disable Exit button on a UserForm | Excel Discussion (Misc queries) | |||
| How to disable the Exit Button of UserForm in Excel? | Excel Programming | |||
| Userform will not exit correctly | Excel Programming | |||
Hybrid Mode
