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

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

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

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

.

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


.

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


.

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


.



.