Thread: Time Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MCheru MCheru is offline
external usenet poster
 
Posts: 70
Default Time Macro

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.