I think the OP wanted the form to appear at regular intervals, like once a
week or once a month. Anything using OnTime or Wait will not be practical
for that kind of delay.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Greg Glynn" wrote in message
...
I find it hard to believe that Chip Pearson's website was not
useful ... The man's a certified genius.

Anyhoo ... Pop a MODELESS form up and loop for 6 seconds like this:

For x = 6 To 0 Step -1
WaitTime = Now + TimeValue("0:00:01")
Next x