Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
dusty_guy107
dusty_guy107 asked in Computers & InternetProgramming & Design · 1 decade ago

Excel VBA screen updating?

I have a fairly lengthy and complex VBA code (at least to me it is) with several subroutines accessing an outside server which then do a variety of calculations resulting in a scatter plot of around 2000 points.

When in the sheet there is often a lag time causing the sheet to respond slowly when you scroll into view of the plot. My question is will the line "Application.ScreenUpdating = False" help this? I know it is traditionally used for inside of macros and then later turned back to true.

So if i leave this set as false will it reduce latency? And can I use lines such as ActiveSheet.Calculate to update the plot only when necessary, or is there a chance the plot wont refresh when called to?

Thank you!!!

Update:

thanks for the answer but, i found that out when i tried it. any other ideas would be appreciated?

1 Answer

Relevance
  • garbo7441
    Lv 7
    1 decade ago
    Favorite Answer

    Screen updating is automatically set to 'True' when a macro terminates, either normally or by 'error'.

Still have questions? Get your answers by asking now.