Vb net excel screenupdating

Application.screenupdating = false I am currently using in Visual Studio 2008 but i was wondering if anyone knows the equivilent for this version.

which obviously isn't working because the screen updates a whole lot afterwards. I almost wish this were more complicated; the fact that everything looks so simple is making it difficult to think of what could possibly be happening! So this morning application.screen Updating was working as expected. The test code that I wrote is below: Sub test() Debug. One thing that seems to be common among those modules not working, is that they all contain code that changes worksheets. In any case, it's a real mystery why this happens from one day to another!

i must admit that my Screen Update does not help to make the code readable so this mistake could have happened to many of us... Screen Updating = False If my Debug = False Then On Error Go To Error Handler I'm afraid that's pretty much it. Screen Updating End Sub As I step through the code when I hove over Application.screen Updating it always says True. Then put it in debug mode and step through with screen updating turned off again, you should find that you still see the numbers going in one by one. Then comment out the line which turns off screen updating and see what happens; you should find that you scroll down the sheet as the numbers get filled.To follow up on Pete and DS, why are you switching between workbooks? Screenupdating=false won't prevent the "switching" from being displayed, so I'm not understanding why you wouldn't see that in 2010 as well.To follow up on Pete and DS, why are you switching between workbooks? Screenupdating=false won't prevent the "switching" from being displayed, so I'm not understanding why you wouldn't see that in 2010 as well.starting from your kind last three posts I checked more thoroughly my code and can state what follows: - I do have "activate" stuff but it resides in subs only with the specific task of taking the user around many open workbooks (rather than having him select them through taskmanager, or alt tab or via the window bottom toolbar) while the main sub (and those called by it), which is called for processing data in all open workbooks, does not make use of any "activate" method at all - my guess about switching between workbooks being the flickering cause was just a guess that turned out to be wrong.

Leave a Reply