View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
One-Leg One-Leg is offline
external usenet poster
 
Posts: 23
Default VBA: PLAY and WAIT

I did but I find this and I tried everything but nothing works:

Example

This example runs my_Procedure 15 seconds from now.
Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure"

This example runs my_Procedure at 5 P.M.
Application.OnTime TimeValue("17:00:00"), "my_Procedure"

This example cancels the OnTime setting from the previous example.
Application.OnTime EarliestTime:=TimeValue("17:00:00"), _
Procedu="my_Procedure", Schedule:=False