Looking to force screen updating in Excel

Reply #2

GASMETERGUY — Fri, 18 Jan 2008 20:27:47 GMT

I hope someone provides an answer to this question. I, too, run VBA and my screen freezes. I can surf the net, play solitaire, ect., but I cannot return to my Excel spreadsheet to check on the progress of my program.

Currently the only way I know to exit a running VBA program is to hit the ESC button. But that halts all execution and returns to the beginning. I have tried SCREENUPDATE = TRUE but that did not work.

Reply #1

time*treat — Sun, 13 Jan 2008 07:40:38 GMT

So far, I'm finding that the scroll command sometimes breaks this up... still working on it.

Looking to force screen updating in Excel

time*treat — Fri, 14 Dec 2007 00:09:58 GMT

When I'm running code, if I switch to some other task (surfing, writing, whatever), sometimes excel will turn off screen updating (that's where you can see the macro progress as it changes cell contents). That means that the spreadsheet is frozen until the macro completes.

I don't see in any of the menu options where it can be forced on. Maybe I missed it? I have even set up a loop to periodically set screen updating equal to TRUE, but this has not helped.

Anyone else run into thi... [ More ]