Time Triggered Events

  • Thread starter Thread starter SLL
  • Start date Start date
S

SLL

Hi all-

I am looking to have excel perform certain events based on time. For
example:

At 8:00:00 AM every morning I want excel to display a message box that
says: "good morning"
At 5:59:50 PM display a message box saying, "go home in 10 seconds"

etc...

My problem is that excel time doesnt automatically refresh/update so I
cannot simply create a function checking the time and then calling
another function...

any thoughts?

Thanks.
 
Sorry, some clarification...

I know there is an autoupdatefrequency that I can adjust on the
workbook open, but I need to check time values by the second...

so my question is probably, how do I get my workbook to update every
second?
 
Back
Top