Speeding up VBA Code: Calculation Mode

Pubblicato il: 21 settembre 2016
sul canale di: 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.

In questa pagina del sito puoi guardare il video online Speeding up VBA Code: Calculation Mode della durata di ore minuti seconda in buona qualità , che l'utente ha caricato The Office Ninja 21 settembre 2016, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 897 volte e gli è piaciuto 6 spettatori. Buona visione!

9,532

225