Recent Addins ADO Application Arrays Charts Commandbars Count Dates Dialogs Events File access Files & Folders Functions Games Help Import & Export Lookup Off topic Other Outlook PivotTables Power Query Printing Problem solving Read me Searching Sorting Sound Strings Sum Time VBA programming VBE Workbooks Worksheets

Prevent a UserForm from closing when the user clicks the x-button

 2000-02-05    Dialogs    0    243

If you want to prevent a Userform from closing when the user clicks the x-button or close-button in the top right corner of the dialog, you can add the macro below to the UserForms code module:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    If CloseMode = vbFormControlMenu Then
        Cancel = True
        MsgBox "You can't close the dialog like this!"
    End If
End Sub
This will also prevent the dialog to be closed when the user presses Alt+F4 on the keyboard.