Bradley H Callender
Board Regular
- Joined
- Aug 5, 2010
- Messages
- 120
How can I keep a user form up until it is used. For example i don't want the user to just close it please give me a macro code for that
Private Sub UserForm_QueryClose _
(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
MsgBox "Clicking the Close button does not work."
Cancel = True
End If
End Sub