Form question
 

Hi All,
I'm sure this is simple, but I can't figure it out.

I have created a user screen that I want to require input before the program
will continue. I don't want the user to get lazy and hit the "X" in the
upper right hand corner.

If there a way to disable the "X"?

Thanks in advance.

Richard Mogy

Form question
 

On Feb 16, 11:04 am, "Rich Mogy" wrote:
Hi All,
I'm sure this is simple, but I can't figure it out.

I have created a user screen that I want to require input before the program
will continue. I don't want the user to get lazy and hit the "X" in the
upper right hand corner.

If there a way to disable the "X"?

Thanks in advance.

Richard Mogy

Morning...

I've used this code....it works very well...

Private Sub UserForm_QueryClose(Cancel As Integer, _
CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
MsgBox "Please use the 'Close button!"
End If
End Sub ' Can not close via the normal red X...

Form question
 

Thank you very much -- worked like a charm!!
"Gimp" wrote in message
oups.com...
On Feb 16, 11:04 am, "Rich Mogy" wrote:
Hi All,
I'm sure this is simple, but I can't figure it out.

I have created a user screen that I want to require input before the
program
will continue. I don't want the user to get lazy and hit the "X" in the
upper right hand corner.

If there a way to disable the "X"?

Thanks in advance.

Richard Mogy

Morning...

I've used this code....it works very well...

Private Sub UserForm_QueryClose(Cancel As Integer, _
CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
MsgBox "Please use the 'Close button!"
End If
End Sub ' Can not close via the normal red X...