Continuous Evaluation of Time Function NOW() ??

[monir]

Hi;

1) The following formula returns TRUE or FALSE:
=AND($J$15<>"",(MOD(SECOND(NOW())-1,6)+10) = COLUMN())
It works fine as long as the w/b is busy doing something!

2) Otherwise if the w/b is not busy, the formula appears to be calculated
only ONCE at the current time NOW(), and F9 must be pressed repeatedly to
re-calculate the formula despite Tools::Options::Calculation is set to
Automatic.

3) Is it possible to have NOW() representing a progressive NOW() ??

4) If not, can the above formula be modified such that it is evaluated
continually for, say, the next 60 or 120 seconds from the current NOW() ??

Your expert advice would be greatly appreciated. Thank you.

 

[Bob Phillips]

If you wanted something like that, you would need a timer in the background
firing off a sheet calculation, something like this

Sub Recalc()
Static myCounter As Long

If myCounter > 60 Then Exit Sub
myCounter = myCounter + 1
ActiveSheet.Calculate
Application.OnTime Now + TimeSerial(0, 0, 1), "Recalc"
End Sub


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)