real time countdown timer function with ticker

Hi everyone I need some help on a macro, This should be an easy one for you guys.


The low down:

I'm playing a game that requires me to keep track of money that is increased by a variable amount (pre-calculated and in a cell) and in a fixed time interval of 51 minutes weather I play it or not so I want to be able to keep track of the progress of the money gain outside of the game.

So, I need to know the macro coding for a real time counter that will increase the total money amount in one cell based on the variable income (declared in another cell) in the 51 minute intervals.

now... I also need excel to keep track of the value increase even if excel is closed (by the difference in time from when excel was closed last).

Keep in mind I'm a total n00b when it comes to excel and programing so please be as clear and precise as possible with the instructions. I have been trying to figure it out myself and so far I have been able to get a real time clock in a cell, and also the coding to translate time to decimals but I have yet to find a counting function in a timed interval so your help would be greatly appreciated.

Thanks.
-Scott

Good morning mrhzoer

...and welcome to the forum!!

There seems to be a couple of questions in here, but none of them are that clear - It all sounds pretty do-able and I can kind of see where you want to go but not what you;re asking.

Can we take one question at a time, if necessary post the code you have (lease use the code tags above - the # button) and we'll see if someone can help.

DominicB

Hi mrhzoer

You want the code amending so that the value will always be shown in A2, and rather than the time being shown, it is a number that increments by 1 every 5 seconds? If that's the case, does thiw work OK for you? Just bear in mind that before you run it you'll have to change the format of cell A2 from Time to something else - General or Number would be fine. the code could benefit from other tidying up, but we'll stick with the basics first :

Please Login or Register  to view this content.

HTH

DominicB

Hi mrhzoer

Originally Posted by mrhzoer

Is it possible have the code running 24/7 and keep counting up even with excel closed and the computer turned off?
and is it possible to make a "reset to zero" button that is linked to the counter?

Cripes!! You don't want much, do you ...

Have a look at the attached file. I've made a complete departure from your code in an effort to tidy the whole thing up. It also starts automatically when the file is opened - that's something I got a bit carried away with, but easy enough to change. When the file is closed, the time and date is written to A3, then when the file is next reopened the difference between the actual time and the timestamp is calculated and converted to seconds and the counter should be updated accordingly, but not had chance to do much testing on it.

HTH

DominicB