tried sth. like that?

'the value of your variable is set here
Application.Wait Now() + Timevalue("00:00:01")
'your code to input the variable into a table



Uzytkownik "MJKelly" napisal w wiadomosci
...
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