Automatic Upate of NOW() function?

[Ed's]

Hey,

I am wanting to find out if the NOW() function can be updated automatically
every 30 minutes - i have a formula which changes a date to tomorrows if it
is after 5pm - but the now function obviously doesn't update automatically.

Can any bodyhelp?

 

[FSt1]

hi
excel is driven by event driven programing. meaning that excel is waiting
for the user to do something. if the user does something, things happen.
updates get updated. the screen changes. wow.
if the user doen't do something....nothing happens....no code runs...just a
monotonous screen display that never changes. kind of like watching paint
dry.
if you want updates to happen ever 30 minutes (like clock work) then...
have a user on call to do something every thirty minutes or...
look into the ontime method in vb help and/or see this site...
http://www.cpearson.com/excel/ontime.htm

regards
FSt1
And after reading this post, i think i have been up too long. or had 1 beer
too many.
both?????

 

[Shane Devenshire]

Hi Ed,

This can be done but you will need to write code to do it. Is that
something you want?

Sub my_Procedure()
Application.OnTime Now + TimeValue("00:30:00"), "my_Procedure"
Application.Calculate
End Sub

This actually calculates the entire application which automatically updates
all volatile functions of which NOW is one. You can limit the area that is
recalculated to a sheet for example. Place the above code in a regular code
module.

Cheers,
Shane Devenshire
Microsoft Excel MVP