MsgBox modification to include clicking the "X"

[zombiemaster]

I have a simple Yes/No message box that will exit the sub if the user clicks "no". I saw on another forum where someone mentioned that we can "add another condition to test the user's response for something else in addition to vbYes (perhaps to test for no response by clicking the X to close the form)", but they didn't actually provide the code...

I haven't been able to find that code that will also exit the sub if the user clicks the "" to exit the message box instead of clicking one of the buttons. I figured if I'd find someone who knew the answer, it would be here...

Here is my existing message box VBA:

    Dim varResponse As Variant
    
    varResponse = MsgBox("                      --==BEFORE RUNNING THIS REPORT==--" 
& vbCrLf & vbCrLf & "--==DOWNLOAD TODAY'S REPORT FROM DOC DIRECT==--" 
& vbCrLf & vbCrLf & "               Have you downloaded the report from Doc Direct?", 
vbYesNo, "Selection")
    If varResponse <> vbYes Then Exit Sub

Thanks for your help as always!
~ZM~

 

[Fluff]

No need to test for clicking the "X" with that code, as you can't, it's disabled.

 

[zombiemaster]

WOW

Is today Monday? Because this just made me FEEL like it's a Monday...

Thanks for the quick help, Fluff!!


~ZM~

 

[Fluff]

You're welcome & thanks for the feedback