Userform close

[Karen53]

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

 

[Nigel]

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

 

[Howard Kaikow]

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

Cancel is an Integer data type, so Cancel = 1 is the preferred coding.

Shhh, don't tell anyone, this is a secret, I've probably done it both ways.

 

[Karen53]

Thank you, Nigel.

--
Thanks for your help.
Karen53

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
(e-mail address removed)

 

[Karen53]

LOL, Thanks Howard