You will want to use the
Application.OnTime Now + TimeValue("00:05:00"), "Proc_Name"

then have the sub or routine named Proc_Name do whatever updating you
want done.

Then at the end of the Proc_Name macro put the same ontime event so it
will recursively call itself.

Keith
www.kjtfs.com


---
Message posted from http://www.ExcelForum.com/