LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Countdown Timer

Here's the Gist:

I have a certain cell (Q16) can can be a 0 or 1, depending on the logic

If the value in Q16 is 1, I want a cell (W8) to start counting down from 15
to 0 in 1 interval seconds in such a way that I can still perform actions on
other cells.

Then, if the value in Q16 gets changed to 0 before the timer is up, the
timer pauses.

And once again, if the value in Q16 turns back to 1, the clock will start at
15 seconds again till it reaches 0.

I'm very new and have been reading up on Worksheet_Change but I am very
unfamiliar with it. Any help is appreciated.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set up countdown timer to countdown days to a specific day Jenny Excel Worksheet Functions 3 May 8th 23 07:43 PM
Countdown Timer Robert_NSBG Excel Discussion (Misc queries) 1 December 11th 08 08:54 PM
Countdown timer Ira Excel Discussion (Misc queries) 7 November 16th 07 01:50 AM
Countdown Timer Saxman Excel Discussion (Misc queries) 1 February 6th 07 09:55 AM
HELP for COUNTDOWN TIMER CC Excel Discussion (Misc queries) 3 May 8th 06 12:44 PM


All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"