LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default Excel (not spreadsheet) Screen refresh while VBA is running

Hello

a relatively basic question but haven't found the solution yet. While
a macro is running in Excel, and when the user selects another
application, the Excel screen is not updated anymore (that's not too
much of an issue) but when the user gets back to Excel and the macro
is still running, the screen is still not updated. That's a bit of an
issue when a very slow macro is running and I want to monitor the
progress, either through Application.Statusbar or through a userform-
based statusbar. The value on display is basically the value as of
when the user selected another application in the first place.

Is there a way to do some sort of Excel Screen refresh or any way
around this problem?

Thanks in advance
Charles
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL 2007 CHART REFRESH WHILE MACRO IS RUNNING MikeM Charts and Charting in Excel 1 April 20th 09 07:38 AM
Excel Screen Refresh Issue in Terminal Server Denis Excel Discussion (Misc queries) 0 February 11th 08 07:26 AM
Force Excel to Refresh Screen Ming Excel Programming 3 September 12th 06 09:52 AM
supress screen refresh when macros running in excel VB drstraw Excel Programming 3 August 26th 05 04:25 AM
running a macro on every refresh of the screen shovit sahai Excel Programming 5 March 2nd 05 10:56 PM


All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"