What does Application.screenupdating means!!!

Hi Forum..

* When its false.. screen should be looks like.. a image.. no update.. and after return true.. current status of the screen..

I think I am right..

but sometime.. when we swap between two sheets/books..
excel window.. looks like only application.. No sheet visible.. only Application Window..
in background program is running..
after completion or set App.ScrUpd = true, its come and display current screen..

I ask looking for a technical explanation.. why screen in flickering.. you know what I mean by flickering.. i don't want user to display blank application.excel.. i just want to show.. the screen just before.. app.ScrUpd = false..

if you need .. i can create a sample fie with with lil bit huge for loop.. and swaping between two sheet.. randomly.. just to show you blank application window.. but i think, you all already have noticed..

Hi, Debraj Roy,

I ran across that when updating charts, and I finally ended up using API and freezing the window from there as before ScreenUpdating was set to False but there was still some action visible.

Alternative might be taking a screenshot from the sheet, minimize Excel to the tray and display that picture for the runtime of the macro, maximize Excel again and delete the image.

Ciao,
Holger

Hi HaHoBe..

thanks for suggestion.. You know.. i follow you a lot.. your excel techniques inspired me a lot.. learned a lot form you..

thanks for suggestion and idea.. still lot of thing to learn..
but i never work on API or infact class module..

for the time being.. i am assuming this is a Redmond guys's fault.. and we need to accept this as this only..

Keep guiding us..

If you are using a loop you can periodically update the display by setting screenupdating to true then immediately back to false...
alternatively you can use event triggers to force a screen update to ensure you're not left with a blank application window display.
To force a chart update you also have to activate the worksheet and an enable events usually does the trick.