I am streaming some data and using the code below to capture the highest
point in the data and display it in a cell. When a new high value is reached
the cell will update. All I need is text to appear in another cell
when the value is updated.
I need the text to show for a time period of a few seconds only.
If it is possible, I would like to be able vary the time period the text appears,
and change the text as necessary.
The text would be "read" by another sheet which will carry ot a function.
Private Sub Worksheet_Calculate()
If [A1] > [A2] Then
[A2] = [A1]
End If
End Sub