Thread
:
Userform close
View Single Post
#
4
Posted to microsoft.public.excel.programming
Karen53
external usenet poster
Posts: 333
Userform close
Thank you, Nigel.
--
Thanks for your help.
Karen53
"Nigel" wrote:
They are essentially the same, vbFormControlMenu refers to the 'X' as the
mode of closing. CloseMode = 0 is the same. Cancel = 1; evaluates to
True.
I use, CloseMode = 0 and Cancel = True
--
Regards,
Nigel
"Karen53" wrote in message
...
Hi,
I need to intercept when the user clicks the 'X' on the title bar to close
the userform instead of my 'Close' button and run code.
In researching on the newsgroup I found two sets of code. I am wondering
what the difference is between the two and which would be better to use.
Choice 1:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then
MsgBox "This option will not close the form"
Cancel = 1
End If
End Sub
Choice 2:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As
Integer)
If CloseMode = vbFormControlMenu Then
' make user do what you want"
Cancel = True
End If
End Sub
--
Thanks for your help.
Karen53
Reply With Quote
Karen53
View Public Profile
Find all posts by Karen53