Excel VBA & Excel Macros: Mastering Excel VBA, Tips and Tricks of VBA Programming and Mastering Excel Macros by HEIN SMITH
Excel VBA Tips n Tricks #21 Control Charts with VBA
As part of our work to help enterprises upgrade to Office ProPlus, we have found that some users have been experiencing slow running VBA, which can be frustrating. The good news is that there are steps which can be taken to improve performance. This post aims to raise awareness of the steps that you can take to improve the performance of your macros, whether you are an end user, IT admin, or developer.
Ten VBA Tips and Tricks
The best way to solve even a very complex problem is to think thru. Next time, when you are about to automate that report or clean some imported data using VBA, just write the logic down on a paper. See and understand various aspects of the problem. The solution becomes clear to you. It has worked for me and it works for you too.
Just move the cursor to the word that interests you and press F1. If you write a VBA macro that produces lots of on-screen action, you can speed things up significantly by turning off screen updating. To do so, execute this statement: If your macro uses a custom dialog box, make sure to turn screen updating back on before displaying the UserForm. Otherwise, moving the dialog box on the screen leaves an ugly trail. Some VBA methods cause Excel to display a confirmation message, which requires the user to click a button.