time generated code

[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?

 

[Bob Phillips]

Yeah, using OnTime. See http://www.cpearson.com/excel/ontime.htm

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Roger Converse]

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