Record data from a dynamically changing cell
Hey everyone,
I am currently a student and have only been learning VBA for about 9 months now so please be patient with me. Thanks. So heres my problem:
I have a cell and the value is changing about every 1/8 to 1/2 of a second, and I need to record the data and the time of the change and store it another sheet so it looks like this:
A B
Time Value
example:
A B
10:01:01:00 5.5
10:01:01:10 6.0
10:01:01:40 7.2
10:01:02:25 4.8
10:01:02:30 3.1
10:01:02:33 3.4
10:01:02:39 3.9
10:01:02:42 3.5
10:01:02:44 4.4
10:01:03:09 5.9
The time of the changes is erratic and so is the values.
I have no idea really how to write the code. My idea was (very basically written):
if value of cell <> previous value of cell then
record change and time of change
I no its very basic idea, and not even code but I am completley stuff on how to code it.
thanks for any help.
Itzadrian