Form question

R

Rich Mogy

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
 
G

Gimp

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
Click to expand...

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...
 
R

Rich Mogy

Thank you very much -- worked like a charm!!
Gimp said:
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...
Click to expand...
 
Top