Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a variables value every second to a table
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a variables value every second to a table
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a variables value every second to a table
Thanks, I'll give that a try, but I need to capture the value of the
variable every second not just when its changed. That way I can plot the duration the variable stays at any value, onto the graph. I need to start a timer when the user starts the process and then capture the variables value each second until the user stops. Not sure how to stop the capturing of the variable either as I would know how many seconds he process will run? Thanks, Matt. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing to a pivot table | Excel Worksheet Functions | |||
Help writing macro for a lookup table | Excel Programming | |||
writing information but not having it look like a table? | New Users to Excel | |||
retain table formatting when writing excel table to a txt file | Excel Programming | |||
writing cells with variables from vba | Excel Programming |