Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
about screenupdating | Excel Discussion (Misc queries) | |||
Screenupdating Problems | Excel Discussion (Misc queries) | |||
What does ScreenUpdating = False do? | Excel Worksheet Functions | |||
ScreenUpdating Problem | Excel Programming | |||
.ScreenUpdating Problem? | Excel Programming |