title: Using VBA Application.ontime for a time tomorrow
body: <p>I have written a timer in VBA in excel using <code>application.ontime</code> that makes a sound and gives a message box when an end time is reached. </p>
  
  <p>This works fine when the time is later in the same day, but when it goes to the next day the timer ends right away, as that time has already passed today.</p>
  
  <p>E.g., if the time is currently 7:00 pm and I want the timer to go off at 6:00 am tomorrow, then the timer goes off immediately because 6:00 am has already passed today.</p>
  
  <p>Is there any way of incorporating the date into the <code>application.ontime</code> call? Am I better off using some other function?</p>