Stop a procedure

[Guest_imported]

Hi,

I have a procedure for construct fractals curves.
How is it possible to stop the procedure during
the execution and stay on the same sheet ?

Excuse my approximate english
Serge Garneau
garnote@globetrotter.qc.ca

 

[swilliams]

Assumptions:
1. the procedure you are using to produce the fractals curve is some kind of loop.

You can have a form with a cancel/stop button displayed whilst the processing is happening. Put a DoEvents statement inside the loop. At the top of the loop check a variable and if false exit the procedure. On click of the stop/cancel button, set the variable to false (initially it should start as true)

Simon