Avoid "flashing" of data - waiting

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I've got a tendious program to run and i want to avoid the "flashing" of the excel sheets when loading the data. I wonder if there are any VBA codes that can allow a "waiting" signal to appear or move to another page when the data is loading( then return to the original page when the loading is done.)

Any methods would do as long as i can avoid the flashing of the data.

Thanks.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
in the beginning have a statement

application.ScreenUpdating=false

at the end before "end sub" introduce the statement

application.ScreenUpdating=true