Hi,

I have a number of routines which change the value of a variable each
time they are activated (by the user). I need to write the value of
this variable every second to a table within the spreadsheet. Is this
possible? I can grab the value and write it to the table but I am not
sure how to:-

1 - Write the code which triggers this each second.
2- Whether or not this would continue to happen as the user activates
other sub routines.

I am then using the data in the table to construct a graph plotting
the changing value of the variable.

Hope you can help?

Kind regards,
Matt