Hi,
I am trying to setup some code to prompt the user at certain times of the
day. So the file is open permanantly and at 7 it displays a certain message
or better still if I could get it to display a certain Userform at that time.
Then show another form at 8 and so on.

the only problem i have with this is the time factor (i presume i would have
the code running permanantly in the background waiting for the next time
interval????) I could get the code to wait but that is not time specific, it
would depend on when the file was opened.....

any ideas?? (it maybe that i am taking this too far, is this actually
possible????)

Hi,

try application.ontime method.

Regards,
Ivan

Application.Ontime is what you need. Chip has a good page on it at
http://www.cpearson.com/excel/ontime.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"westg" wrote in message
...
Hi,
I am trying to setup some code to prompt the user at certain times of the
day. So the file is open permanantly and at 7 it displays a certain
message
or better still if I could get it to display a certain Userform at that
time.
Then show another form at 8 and so on.

the only problem i have with this is the time factor (i presume i would
have
the code running permanantly in the background waiting for the next time
interval????) I could get the code to wait but that is not time specific,
it
would depend on when the file was opened.....

any ideas?? (it maybe that i am taking this too far, is this actually
possible????)

Fantastic, thank you both very much!

Regards, Andrew.

"westg" wrote:

Hi,
I am trying to setup some code to prompt the user at certain times of the
day. So the file is open permanantly and at 7 it displays a certain message
or better still if I could get it to display a certain Userform at that time.
Then show another form at 8 and so on.

the only problem i have with this is the time factor (i presume i would have
the code running permanantly in the background waiting for the next time
interval????) I could get the code to wait but that is not time specific, it
would depend on when the file was opened.....

any ideas?? (it maybe that i am taking this too far, is this actually
possible????)