time generated code

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Is it possible to, at the same time every day, open a workbook or recalc it
if it's already open, perform some test on a date field and if the condition
is true, generate a popup or msgbox? Can you make the message box appear on
top of all windows?
 
Check out the OnTime method in the VBA helpfile.

Here's a great overview from Chip Pearson: Scheduling Events With OnTime And
Windows Timers

Hope that helps,
Roger
 
Back
Top