I have macros that run for several minutes (usually updating an Oracle
database)
I update the StatusBar to indicate progress, like:
if (nRec mod 1000 = 0) then Application.Statusbar = "Processing " & nRec &
" of " & nRecordCount
I've noticed that after a few cpu cycles, Excel goes into "Backg
Excel process to
Above Normal or High.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: Friday, October 26, 2012 5:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel 2010 VBA Priority
I have macros
ff
To: excel-macros@googlegroups.com
Sent: Fri, October 26, 2012 3:09:02 PM
Subject: RE: $$Excel-Macros$$ Excel 2010 VBA Priority
Hi Paul,
I don't know the answer to your whole question, but using DoEvents periodically
should ensure you can interrupt the macro, that screen painting c