Continuous Evaluation of Time Function NOW() ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

monir - 04 Mar 2008 04:40 GMT

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.

Reply to this Message

Bob Phillips - 04 Mar 2008 09:40 GMT

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

Signature

HTH

Bob

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

> Hi;
>
[quoted text clipped - 13 lines]
>
> Your expert advice would be greatly appreciated. Thank you.

Reply to this Message