Simple Real Time Counter Macro to start when prompted

[RichTea88]

Good Morning all,

I was wondering if anyone had a code/any idea how to write a macro for a real time counter.

The concept is simple - When the user clicks on the tab a Yes/No box will appear 'Would you like to play a game'. and if the user clicks yes, a counter will start incrementing from 1-10000, increasing the cell value by 1 every half second.

Is this possible? The counter would be in Cell A1

Kind Regards

R

[SoulPrisoner]

Hi richtea,

prehaps you can do infinite loop but that may not be what you´re looking for (u create a loop that runs another macro with a little delay - i´m sure u can use seconds but dunno about half seconds, prolly that would be different syntax that i usualy use and at the end of the macro you run the previous one with the loop...) the problem is, user wont be able do anything whilst that is running and it will run forever - OR if you know you want to run it up to 10K seconds you can make a condition there so the loop stops if the targeted cell has reach your number

Best regards

Soul

[SoulPrisoner]

btw. to give you some start up code:

Please Login or Register  to view this content.

this adds 1 to A1 every second

[RichTea88]

Thanks for the Info SoulPrisoner

This is what I ended up going for, it wasn't fast enough at one second so I had to find a way to include miliseconds.

Please Login or Register  to view this content.