Multiple countdown timers based on cell input.

[Stopnaggin]

Hello all, first time poster. I hope I am not breaking any forum rules already. What I have is a workbook that I want to have multiple timers in different rows based on a a word put into a cell in that row. When that word is entered I would like a timer to start based on some other times in different cells. All the times in this sheet are very fluid. I found a post here very close to what I need but I get errors when i try to run it. Any help would be great.

What I'm looking for is a way to start a countdown when I type "Researching" into column C through K. The time would start from the data in column Q. Any of the other formulas to get the time in Q can be moved to accommodate space needed for the countdown timer.

[LJMetzger]

Hi Stopnaggin and welcome to ExcelForum,

See the attached file which which uses one timer and several helper columns to do what you want. I implemented the software on a separate sheet, because it was a lot easier to test. It is relatively simple to use your sheet, but I need to know what you want, and where you want it, if you need help implementing the software to your file.

Please let my know if you have any questions, problems or if you need further assistance.

Make sure you have a backup copy of your file before you do anything.

The software works as follows:
a. A timer starts that runs once every 60 seconds. You can change the value to anything you want, but a multiple of 10 or 30 is suggested.
b. When Column 'C' thru 'K' changes to 'Researching', column 'R' thru 'V' are filled out for that row.
c. When Column 'C' thru 'K' changes to 'Researching' again, the Projected Completion Date/Time is recalculated.
Subsequent 'Researching' changes in a row can be ignored by setting cell 'U21' to 'Yes.
d. The only extra column that is required is Column 'T' (Projected Completion), the other columns are displayed for informational purposes only.
e. Processing will resume where it left off, when a closed file is opened (provided the file was saved).

In the ThisWorkbook code module

Please Login or Register  to view this content.

In the Sheet module (you must copy the code to your Sheet module to implement the code by yourself):

Please Login or Register  to view this content.

Code continued in next post due to size limitations.


Lewis

[LJMetzger]

Code from previous post continued:

In an ordinary code module such as ModTimer:

Please Login or Register  to view this content.