Challenging! How to record changing values in a cell
Posted by Leong Chen Howe on November 16, 2001 12:20 AM
I have created a cell whose values changes every 5 seconds. The range of value change is between 0 and 100. How can I record the every value change in other cells of worksheet?
If cell A1 = 5, store value 5 in cell B1
if cell A1 = 10, store value 10 in cell B2
if cell A1 = 55, store value 55 in cell B3
Posted by Dank on November 16, 2001 5:14 AM
Assuming you just want to track the value of A1 here's one way you could do it...
Right click the worksheet tab and enter this code:-
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Then Exit Sub 'Only interested in cell A1
Range("B65536").End(xlUp).Offset(1, 0).Value = Target
End Sub
Hope it helps,
Daniel.
