Can you trap the Close button (red X) on a Userform?

R

rick

Is it possible to get an error code or an event when the user clicks on the
form close button?

Thanks.

... rick
 
D

Dave Peterson

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
msgbox "You clicked the X"
End If
End Sub
 

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

Program buttons to create a word document 0
Hyperlink fails to open on the first click 0
How do I set focus (and select text) on a text box on a modeless userform? 0
closing another file by code causes failure to run workbook activate event 2
Close Userform 1
Click on userform transfers to lisbox below 1
UserForm_Terminate problem 2
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0

Top