Running Macro with B/ground Timer
 

I am trying to wite a macro which has a countdown timer on
screen while waiting for inputs via screen buttons to
increase or decrease scores. Any idea how to do this
would be greatly appreciated.

Running Macro with B/ground Timer
 

Application.OnTime is what you're after.
I have an example on my website

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Damian Lee" wrote in message
...
I am trying to wite a macro which has a countdown timer on
screen while waiting for inputs via screen buttons to
increase or decrease scores. Any idea how to do this
would be greatly appreciated.

Running Macro with B/ground Timer
 

Thanks heaps - works well
-----Original Message-----
Application.OnTime is what you're after.
I have an example on my website

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Damian Lee" wrote in message
...
I am trying to wite a macro which has a countdown timer
on
screen while waiting for inputs via screen buttons to
increase or decrease scores. Any idea how to do this
would be greatly appreciated.


.