Break out of loop

right now I am using the DoEvents statment withing my loop to allow the user to click on buttons while the loop is running, a cancel button to be specific, the command that I am using when that button is press is END, this works great for the most part however that command completly stops the macro and exits everything, If I put any code after that statement, it does nothing, I was wondering what I would need to do to keep the form from closing?

Hello Mpeplow,

To exit a FOR loop use Exit For
To exit a DO loop use Exit Do

To exit a SUB use Exit Sub
to exit a FUNCTION use Exit Function

Sincerely,
Leith Ross

Hello Mpeplow,

To solve your problem, I would need to see your code. Since this involves a UserForm, it would be best if you post the entire workbook as an attachment.

Thanks,
Leith Ross

I would love to so you could help me, however, unfortunatly, I cannot post the entire workbook. I'm working with propriatary information, I would probally get in alot of trouble for posting it. I have been looking over my code and think that I can use the information that you gave me to force it to work how I want it to.

Thanks!