Copy an ever changing value from one cell into another

[AnthonyRP]

Greetings, I am trying to copy a value which is constantly changing in one cell into another cell thereby creating a list or history. The worksheet is already updated constantly (sub second timeframe). I am trying to get this to occur at specific intervals, every 5 seconds. I have intermediate standard excel experience but not much experience with VBA. I have searched the threads and not found anything that addresses this specific problem. Any help or suggestions provided would be greatly appreciated. Thank you for your time.

Anthony

[sintek]

Hi Anthony

Have a look at this link to see if it is of interest....It gives a formula and VBA solution.
https://www.quora.com/How-can-I-reco...-point-in-time

[AnthonyRP]

This is similar to what I want done from the link you have provided:

______________________________________________________________________________________________________________________________
'These subs must go on the ThisWorkbook code pane. They won't work at all if installed anywhere else!
Private Sub Workbook_Open()
dNextTime = TimeSerial(9, 30, 0) 'Run the CaptureHeadlines sub at 9:30 AM
dNextTime = Date + dNextTime + IIf(Now > (Date + dNextTime), 1, 0)
Application.OnTime dNextTime, "CaptureHeadlines"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnTime dNextTime, "CaptureHeadlines", Schedule:=False 'Cancel the CaptureHeadlines scheduled run
End Sub
______________________________________________________________________________________________________________________________
'This code must go in a regular module sheet. It will not work at all if installed anywhere else! Make sure the Public statement is above any subs or functions.
Public dNextTime As Double

Sub CaptureHeadlines()
Worksheets("Sheet2").Range("A1").Value = Worksheets("Sheet1").Range("A1").Value
dNextTime = dNextTime + 1
Application.OnTime dNextTime, "CaptureHeadlines"
End Sub
______________________________________________________________________________________________________________________________

However, I want the data copied every 5 seconds, ALL DAY not just once a day at a specific time. Ideally it would be best to be able to plug in start and stop times.