chane what 'x' button on top right of the form does

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

How can I code the 'x' button located on the top right of the form such that
it quits the application? or make it do something that I want.

Thanks in advance
 
paste behaind form:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

If CloseMode = 0 Then

'do something

MsgBox "You Pressed X"

End If

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing The Quit/X Button On An Userform 7
Remove/Inactivate "X" in UserForm 1
UserForm - Disable the 'x' button 11
Userform Question 3
form buttons on sheet collapse on unhide - sometimes 5
button names changed on copied sheet 4
Disable UserForm 'X' Close Button 2
Close X button on Usser Form 1

Back
Top