I have a range D9:O9. Each cell in that range has a separate time in it
ranging from 5:30am to 8:30am. So for example, E9 has the time 6:00am in it
while J9 has the time 6:50am in it. Is there a code that will cause a
message box to pop up when the actual time reaches the time entered in each
cell? So for example when it becomes 6:00am because 6:00am has been entered
into E9 a message box will pop up letting you know that it is now 6:00am.

This may get you started:
http://www.cpearson.com/excel/ontime.aspx

Good luck,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"MCheru" wrote:

I have a range D9:O9. Each cell in that range has a separate time in it
ranging from 5:30am to 8:30am. So for example, E9 has the time 6:00am in it
while J9 has the time 6:50am in it. Is there a code that will cause a
message box to pop up when the actual time reaches the time entered in each
cell? So for example when it becomes 6:00am because 6:00am has been entered
into E9 a message box will pop up letting you know that it is now 6:00am.