Hi
maybe the OnTime method is what you're looking for for running a macro
periodically. chip has some instructions on his site how so set-up such
a macro:
http://www.cpearson.com/excel/ontime.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Radionise wrote:
hi all,
im quite new to VBA.
i have done this one module to generate email to several recipients
when some process parameter(s) are operating abnormally.

but i dont really know how to get this module to auto repeat itself
after let say an interval of 5 minutes.

kindly help...

thank you.