Re: NEXT LEVEL OF ScreenUpdating

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


>>Any comments?<<

Hmmmmmmmm........

For a start....

The grey box appears when the macro starts. It persists until the
macro ends.

It all points to Windows not processing it's message queue fast enough.
Your macro starts->Grey box. Your macro ends->No grey box.

The more I think about it, the more I'm convinced that it's all to do
with the above.

Have you managed to figure out what the grey box is yet ? Is an empty
tool bar ? Could it be part of another window showing where the screen
has yet to be refreshed ?

The fact that your message box is displayed is because it is waiting
for user input so it has relinquished control.

Just out of interest (I can't remember whether you've said so or not),
have you tried placing doevents statements in your code ? Especially in
loops ?

One of the reasons why I'm convinced (I may be wrong though...) that
it's all to do with the above is that I use Excel on a regular basis as
a halfway house for legacy data on it's way from mainframe systems being
uploaded into SAP. This data can take up many spreadsheets in a
workbook and contains hundreds of thousands of rows in some cases
(especially whey you're dealing with general ledger postings etc) We do
lots of validation and data cleaning, all automated with VBA. Without
liberal usage of Doevents in the code, windows don't open, screens
don't refresh and you also get blank boxes (not always grey though....)
that persist until the macro ends. As these things run for hours that's
a bit of a problem....

By using DoEvents, you can get your system to work with almost no
degradation while these things churn away in the background.

The more I type, the more I'm convinced.

Let me know.

Regards

Rich


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24737
View this thread: http://www.excelforum.com/showthread.php?threadid=385041

.

Relevant Pages

  • Re: NEXT LEVEL OF ScreenUpdating
    ... I inserted a MsgBox before the first line of executable code. ... macro is named 'Auto_Open' and is triggered via a Windows' Scheduled ... The grey box appears when the MsgBox does (actually, ...
    (microsoft.public.excel.programming)
  • Re: Pasting text without attributes/formatting
    ... change the default behaviour of pasting in Windows so it does this in any ... > paste command in Windows. ... However, in Word, you can use a macro to ... >> Jonathan Finney ...
    (microsoft.public.word.pagelayout)
  • Re: Word 2007 Save As
    ... should apply to all of Windows, not just Word and not just Word 2007. ... it may help if you post the part of the macro code ... The error message came from Microsoft Office Word. ... This happened (all templates and words at network) when I open template ...
    (microsoft.public.word.vba.customization)
  • Re: difference between XL VBA on Windows and the Mac???
    ... difference between XL VBA on Windows and the Mac??? ... This same macro runs fine on a Windows computer. ... Excel on a Mac uses the VBA equivalent of Excel 97. ...
    (microsoft.public.excel.misc)
  • Re: MACRO for dual screen screen captures pasted into PPT.
    ... ALT PRINTSCREEN wont fill the requirement because I need to capture multiple ... Selection: Invalid request. ... Select the pasted picture each time before running the macro. ... SOFTWARE is Office 2007, Windows XP. ...
    (microsoft.public.powerpoint)