M
MJKelly
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
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