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.

--
SLL

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?

On Sep 4, 6:46 pm, SLL wrote:
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.

--
SLL

Check out this link...

http://www.cpearson.com/excel/OnTime.aspx
--
HTH...

Jim Thomlinson


"SLL" wrote:

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?

On Sep 4, 6:46 pm, SLL wrote:
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.

--
SLL