stop a program
 

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

stop a program
 

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

"don bowyer" wrote:

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

stop a program
 

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

stop a program
 

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

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

"don bowyer" wrote:

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

.

stop a program
 

Hi Stephen

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

-----Original Message-----
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


.

stop a program
 

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




---
Regards,
Norman



wrote in message
...
Hi Stephen

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

-----Original Message-----
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


.

stop a program
 

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

-----Original Message-----
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




---
Regards,
Norman



wrote in message
...
Hi Stephen

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

-----Original Message-----
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


.



.