Find LOW or HIGH from a live cell

[MktVBA]

In VBA, I have cell A1, that is a changing(live) number. In cell B1 I want to register the lowest number that appeared in cell A1, over a certain time, like last 10 minutes.
Any idea, what would be the best way to do this, in excel or VBA?

Best

Bern

 

[circledchicken]

Hi,

I'm not sure if this will work or if it is a correct way of doing things, but it's an option you can try:

Sub Try()

Dim oStop As Long
Dim iStop As Date
    
For oStop = 1 To 6
    Range("B1") = 9.99999999999999E+307
    
    iStop = Now() + TimeValue("00:10:00")
    Do Until Now() >= iStop
    DoEvents
        If Range("A1") < Range("B1") Then
            Range("B1") = Range("A1")
        End If
    Loop
Next oStop

End Sub

This 'theoretically' will loop for an hour, registering the lowest number within the 10 minute period and re-setting every 10 minutes.

 

[MktVBA]

Thanks you, will try this