Hi all,

I am wondering what code do I need to stop the userform closing when the X
button is clicked?

Thanks in advance

Greg

Something like this:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
End If
End Sub

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy


"Greg B" wrote:

Hi all,

I am wondering what code do I need to stop the userform closing when the X
button is clicked?

Thanks in advance

Greg

Thank you for your answer

Greg

"Tom Ogilvy" wrote in message
...


Something like this:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
End If
End Sub

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy


"Greg B" wrote:

Hi all,

I am wondering what code do I need to stop the userform closing when the
X
button is clicked?

Thanks in advance

Greg