Screenupdating
 

Hi

I have a big problem at work. I'm looking for a VBA-script tha
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 thi
http://www.excelforum.com/t173754-s

Fu manch

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

Screenupdating
 

Fu,

What have you done so far, and what is happening/not happening?

I presume you have tried the OnTime method?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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/

Screenupdating
 

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/