UserForm Issue

[madchemist]

I have a user form that I created that I want to prompt users to make sure they intended to hit a macro button that is not reversible.

After they read the warning, they click Yes or No, or the red X in the upper right corner.

I prompt the warning in the code just using:

frmWarning.show

So If they click yes, shouldn't I just use the following code to exit the form and have the macro continue?

Private Sub frmWarning_Click()
  Unload Me
End Sub

Even when they click no or the red x, the macro is continuing. What do I write for the code the kill the macro?

Would I just use Kill, or is there some other command that will stop it? Also, how do I write the code for the red X button?


Thanks!

 

[erik.van.geit]

Hi,

You can use a messagebox to ask anything you want.

Sub test()
Dim response As Integer

response = MsgBox("continue?", vbYesNo, "title")
If response = vbNo Then Exit Sub

MsgBox "macro continues"

End Sub

kind regards,
Erik

 

[QuietRiot]

exit sub = to kill

then in the click part just call the macro you want run

 

[Norie]

To stop all code.

End