Cancel out of a routine which calls other routines 1

[wusinik]

I am tring to have an option available to users so that when a user hits a command button which triggers a long process, a "cancel" button can be available so that they can go back to the main form. I'm having trouble truly exiting out of the routine b/c the routine which sends the time-consuming process off calls other routines... any ideas??

 

[Niv3k]

Maybe have a boolean variable named bCancelled, and before every line of your code in the one button do a

DoEvents
If not bCancelled Then

code

Then inside the Cancel Button just set bCancelled=True

It's kinda ugly, but it works.

Kevin