I am running the following piece of code to record the value of cell A1 every second, to create a list of values. I also want to chart the values in real time, ie have the chart update whilr the code is running. However while the code is running, this currently doesn't occur, and I can't even use excel at all until I break the running macro. Is it possible to have the macro "pause" to allow this?
Sub Log()
For a = 2 To 240 Step 3
For b = 1 To 1000
Cells(b, a) = Time()
Cells(b, a - 1) = Cells(1, 1)
PauseTime = 1
Start = Timer
Do While Timer < Start + PauseTime
Loop
Next b
Next a
End Sub
2007-12-10
04:07:51
·
4 answers
·
asked by
Chin
2
in
Programming & Design