Fu Manchu, try:

Application.OnTime Now + 2/1440, "macroToRun"

to run the macro named macrotorun every two minutes.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Fu Manchu " wrote in message
...
Hi

I have a big problem at work. I'm looking for a VBA-script that
autoopdates my screen every 2, 5 or 10 minuts.

I've been looking at "OnTime" but I can't seem to get it right at all.

Excuse my english...

I hope someone can help me with this. And I've benn looking at this
http://www.excelforum.com/t173754-s

Fu manchu


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