MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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,