store RTD updates

[adilift]

Hi;
I am receiving RTD price streams in cell A1. How can I go about storing the RTD price updates in excel for that particular cell.
Any help is appreciated

Adil

 

[PA HS Teacher]

Could explain to a novice such as myself what that means?

Does the value of cell A1 change periodically?

And you would like to keep a list of these values somewhere?

 

[adilift]

RTD is similar to DDE. RTD is "real time data" that excel is receiving from a RTD server. The value in the cell "A1" with RTD link changes dynamically. I would like to somehow capture these RTD updates and store them on an excel sheet.

Adil

 

[PA HS Teacher]

Assuming you have a blank sheet name "Sheet2"

Hit Alt+F11 to bring up the VBA editor
On the left should be a window.
Look for the name of the sheet that has the dynamically updated cell.

click on it.

Choose Worksheet on the first drop down menu.
Choose Change on the drop down menu and paste the following code.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("A1").Address Then
  Worksheets("Sheet2").Cells(65536, 1).End(xlUp).Offset(1, 0).Value = Target.Value
End If
End Sub