Screenupdating

  • Thread starter Thread starter Fu Manchu
  • Start date Start date
F

Fu Manchu

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
 
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, 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
 
Back
Top