When screen updating is turned off, toolbars remain visible and Word still allows the procedure to display or retrieve information using status bar prompts, input boxes, dialog boxes, and message boxes. The ScreenUpdating property controls most display changes on the monitor while a procedure is running. Avoid 'Screen Flickering' or 'Screen Repainting': UseĪpplication.ScreenUpdating = False 'To Turn Off at the start of code.Īpplication.ScreenUpdating = False 'To Turn on at the end of the code. So streamline your program logic and get the best performance of macros. Without a good logic, a good written VBA macro program has no value. Analyze the logic: Before optimizing the syntax, pay more attention in optimizing the logic.
Use Worksheet Functions wherever applicable Do read full article to understand the logic behind them. Use 'Early Binding' rather 'Late Binding' 16. Reduce the number of lines using colon(:) 10. Wish my readers a very MerRy ChRisTMaS !ġ. Read them carefully and open new pathways of innovation in creating excel dashboards, reports and automation. VBA programs are known to save a lot of time and now this post is to save further time. It contains both the knowledge and good practices which if followed and used effectively then it might put you in elite category of excellent VBA programmers. On the eve before Christmas, I'm writing this article on VBA code optimization for my blog readers as a gift.
0 kommentar(er)
