PDA

View Full Version : Solved: Kill Macro from UserForm



Zack Barresse
08-16-2004, 04:51 PM
How would I kill a macro - just end it all - from a userform called from a macro?

Brief description:
Macro is called.
Userform is called
If Cancel, Exit userform & macro
else continue macro.

I think I'm over scrutinizing this a little bit..

Jacob Hilderbrand
08-16-2004, 05:11 PM
Use the End statement to stop ALL code.



If (Cancel Command Button Is Pressed) Then
End
Else
'More Code Here
End If

Zack Barresse
08-16-2004, 06:04 PM
Ah, very cool! I didn't know you could do that, exactly what I was looking for. Thanks Jake! Youdda man!! :)