counting the number of tym a macro has been run

[Suraj3825]

i have created 8 buttons and assigned them to 8 different macros. it is necessary for me that i find out how many tyms each of this macro button has been pressed.
and also can i tabulate that data(of how many tyms its been pressed) ??
and can i refresh it on choice so that it starts counting form zero again wenever i want??

[jeffreybrown]

You would have to setup the macro to store the value somewhere.

Example:

Please Login or Register  to view this content.

Everytime you press the button the macro runs and then records a number in A1. Press it again and you have A1 + 1 which will be 2 since this is the second time the button has been pressed.

When you want to start the count over again just change A1 to 0.