stop a program

[don bowyer]

I have a program which runs a clock loop.
I want to stop it at any time by one mouse click of
something - a toolbar or worksheet button - whatever.
I can of course stop it by Ctrl + BREAK.
It's the code to do the stopping I can't get - rather than
the means of applying it.
I assume the appropriate code would have to go into the
loop so that the stopping instruction is seen at each pass.
Can anyone please help.
Don

 

[Guest]

are you wishing to stop it at something specific or just stop it like a
screen saver? as soon as anything is done?

 

[Stephen Bullen]

Hi Don,

I have a program which runs a clock loop.
I want to stop it at any time by one mouse click of
something - a toolbar or worksheet button - whatever.

The CheckKey example on my web site uses a key press to stop a loop, if
that's OK.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

 

[Guest]

Hi Ben
I want to make it stop at any time I choose and I want to
do something specific to make it stop.
Don

 

[Guest]

Hi Stephen

Wonderful as your WS is, I can't find your CheckKey
method. Please give me a pointer>
Don

 

[Norman Jones]

Hi Don,

You will find the CheckKey download in Stephen's 'They Said it Couldn't be
Done' section at:

http://www.oaltd.co.uk/Excel/SBXLPage.asp

 

[Guest]

Hi Norman
Sorry for belated thanks, bur=t thanks. I found it, and
used it successfully.
Regards Don