Speeding up VBA Code: Calculation Mode

Veröffentlicht am: 21 September 2016
auf dem Kanal: The Office Ninja

897

*********************************
Get my VBA Troubleshooter course for only $10 http://goo.gl/S5GIBk
*********************************

Speeding up VBA Code: Calculation mode

Video description
----------------------------
The goal of my Excel VBA tutorials are to take you from a beginner level to a confident Excel VBA developer and programmer as quickly as possible. The best way to do this is to help you UNDERSTAND Excel VBA code and how to build robust Excel spreadsheets.

One of the most common requests from people writing VBA code in Excel is "how do I speed up my VBA code?". The Speeding up VBA Code series aims to give you some quick and easy to implement techniques to speed up your code.

In this free beginner level Excel tutorial we use Microsoft Excel 2016 and you will learn:
1. How to set up various subroutines and functions that will time how long a given piece of code is taking using the "Timer" VBA function;
2. How to set up your VBA code to grab certain application level variables (and allow us to restore them);
3. How to switch your calculation mode from automatic calculation to manual calculation;
4. How to switch your code so it does not calculate before save;

Once we do all of the above we then demonstrate some performance improvements from running an example recorded macro (not the best example but it will do for now).

The video uses Excel 2016 but the same steps are used for Excel 2010 and Excel 2013.

If you enjoyed this short tutorial then please add a comment, start a discussion, "Like", "Favourite" or "Share" the tutorial and subscribe to my channel.

Channel Links and Playlists
----------------------------
   / @theofficeninja
Understanding VBA Code playlist:    • Understanding VBA Code: Uber Lock down of ...
Official Channel Series:    • Microsoft Access Database Parameter Querie...

Other Useful Links
----------------------------
My facebook Page can be found here:   / paulslearninglounge
My Blog sometimes has VBA/Excel related content: https://www.theartofquantfinance.com
A full list of my Udemy courses can be found on my Udemy profile page: https://www.udemy.com/user/paulmorris...
My Excel VBA Troubleshooter course is here: https://www.udemy.com/become-a-vba-tr...
You can often find deals on my current and upcoming Udemy courses here
https://www.theartofquantfinance.com/...

WiseOwl provides a lot of very good VBA tutorials:    / @wiseowltutorials
Sali Kaceli provides a lot of Excel and VBA related tutorials also:    / skaceli
Chip Pearson has a lot of VBA content - if Chip says you should do something ... you probably should: http://www.cpearson.com/

Thanks for watching!

Paul.

Auf dieser Seite können Sie das Online-Video Speeding up VBA Code: Calculation Mode mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer The Office Ninja 21 September 2016 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 897 Mal angesehen und es wurde von 6 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

9,532

225