Insert time in another column when a column containing RTD updates values

[dsenff]

Hello,

I have a spreadsheet that has RTD (real time data) and I would like to create a macro that

when the values of column “B” with 1000 cells with RTD update their values, automatically record in the corresponding cells next to these values (column “A”) the hour, minutes, seconds and milliseconds.

And if any cell in column “B” is blank, leave the time cell blank.

I managed to make a macro, but it only works for a specific cell, I need the macro to work for a column with 1000 cells.



Private Sub Worksheet_Calculate()
If Range("B2").Value = "" Then
Range("A2").Value = ""
Else
Static oldval
If Range("B2").Value <> oldval Then
oldval = Range("B2").Value
Range("A2").Value = Application.WorksheetFunction.Text([now()] - tStart, "h:mm:ss.000")
End If
End If
End Sub

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Insert time in another column when a column containing RTD updates values
and here Insert time in another column when a column containing RTD updates values
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[dsenff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Insert time in another column when a column containing RTD updates values
and here Insert time in another column when a column containing RTD updates values
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Ok, very sorry for the cross-posting.
Won't happen again.

 

[Fluff]

Can you please supply links to any other site where you have asked this question, as requested.

 

[dsenff]

Can you please supply links to any other site where you have asked this question, as requested.

Hi, these are the other sites:

https://stackoverflow.com/questions/...-rtd-updates-v
https://www.excelforum.com/excel-pro...es-values.html