Understanding VBA Code: Declaring Variables with Dim

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

Understanding VBA Code: What if we Don't Declare Variables?

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.

This free beginner level Excel VBA tutorial is the first in a series which deal with variables in VBA and we use MS Excel to demonstrate the concepts.

We start with a blank spreadsheet and gradually build a VBA function for calculating the forward price of a given asset. While doing this we make sure we declare our intermediate variables within the function ... but we do this using only the Dim keyword (we don't specify the variable type).

We open up the locals window within the Visual Basic Editor and step through the code while executing so we can take a look at the variables that are created. We find that VBA creates new variables when they are declared but gives them a Variant data type (rather than the more appropriate Double data type). This is different to the case where we don't declare variables since we are not allowing VBA to decide WHEN to create variables but we are allowing it to decide on the data type it creates.

The video uses Excel 2016 but the same steps are used for Excel 2010 and Excel 2013. The exact same principles also apply to MS Access 2010, 2013 and 2016.

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
----------------------------
https://www.youtube.com/channel/UCY-6DstZI7EDeIP2rgKhTAQ?sub_confirmation=1
Understanding VBA Code playlist: https://www.youtube.com/watch?v=qfqcIZWumsE&list=PLPTvzeeVEaJeghzj3tame6s1-QT6QRxGc
Official Channel Series: https://www.youtube.com/watch?v=l1fV227ugd8&list=PLPTvzeeVEaJdR1f8AEzKDXb9TTMcnQHL7

Other Useful Links
----------------------------
My facebook Page can be found here: https://www.facebook.com/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/paulmorrissey4/
My Excel VBA Troubleshooter course is here: https://www.udemy.com/become-a-vba-troubleshooter
You can often find deals on my current and upcoming Udemy courses here
https://www.theartofquantfinance.com/udemy

WiseOwl provides a lot of very good VBA tutorials: https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw
Sali Kaceli provides a lot of Excel and VBA related tutorials also: https://www.youtube.com/user/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.