Slow calcs with VBA open? (1 Viewer)

CedarTree

Registered User.
Local time
Today, 18:18
Joined
Mar 2, 2018
Messages
404
Hi - I have an XLSM file running and it calculates REALLY slowly when I'm viewing code. When I close the view code window, the calculation happens very quickly. You can the VBA window flashing as if it's updating the screen as it calculates. Any cheats to make re-calculating faster with VBA open?
 

Ranman256

Well-known member
Local time
Today, 18:18
Joined
Apr 9, 2015
Messages
4,339
turn off screen updates:
Application.ScreenUpdating = false
 

CedarTree

Registered User.
Local time
Today, 18:18
Joined
Mar 2, 2018
Messages
404
Cool - I added a button - turns off updating / calculates / turns it back on. Thanks!
 

Isaac

Lifelong Learner
Local time
Today, 15:18
Joined
Mar 14, 2017
Messages
8,738
This is very interesting, and something I've never experienced (or at least, noticed) before. Thanks for sharing. So this had nothing to do with VBA code running ... simply that if you had the VBA project window open at all, then regular worksheet calculations/formulas were extra slow to refresh. Very interesting! I wonder why.
 

Users who are viewing this thread

Top Bottom