Stop macro from running

[drluke]

I've read so many threads, but still cannot determine what code to use:


When the cancel button is clicked in a userform I want everything to stop. Data entered in the userform to be lost, the macro that called the userform to stop completely, and cell A1 of Sheet 1 to be selected.


Should be so simple ..........

 

[gallen]

I've never needed this but also have never heard of the ability for a macro to interrupt a macro. Unless there is a coded interruption, eg a message box, the code will continue run until either it completes, it hits an error or the user hits [Ctrl] + [Break]