Sometimes the table is very slow, until i minimize excel

[jqfranco]

Good Morning .
I searched a lot for a problem similar to mine and couldn't find it.

I have an excel sheet with several tables, where I make some Loops through all its lines looking for information.
During the Loop, I open a form window with a bar that shows the progression in the table.
On many occasions the progression is fast, but sometimes it gets so slow that it takes 5 seconds or more on each row of the table, which makes everything extremely slow.
But...if I minimize excel, I see that the progression in the form window becomes fast again.
I re-maximize Excel and everything is normal.
Is there any reason why this happens?
If the code was wrong and slow, it would always be slow, right?

Thank you for your help.

 

[SanjayGMusafir]

Good Morning .
I searched a lot for a problem similar to mine and couldn't find it.

I have an excel sheet with several tables, where I make some Loops through all its lines looking for information.
During the Loop, I open a form window with a bar that shows the progression in the table.
On many occasions the progression is fast, but sometimes it gets so slow that it takes 5 seconds or more on each row of the table, which makes everything extremely slow.
But...if I minimize excel, I see that the progression in the form window becomes fast again.
I re-maximize Excel and everything is normal.
Is there any reason why this happens?
If the code was wrong and slow, it would always be slow, right?

Thank you for your help.

I think that can be resolved by stopping screen updating during the process and allowing Screen Update after the process. This helps excel to do the process in background and thus makes most calculation and output faster.

Application.ScreenUpdating = True

True to update (after loop), False to Stop update (before loop)