Understanding VBA Code: How to Open the Visual Basic Editor in Excel

Описание

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

Understanding VBA Code: How to Open the Visual Basic Editor in Excel

In Microsoft Excel, when we want to do some coding in Visual Basic for Applications (VBA) we first need to open up the Visual Basic Editor (VBE). There are three key methods I tend to use to do this:
1. Using the Developer Ribbon Tab
2. Using a shortcut key combination
3. If we have a macro assigned to a button then using this to go directly to our procedure

In this beginner level tutorial I walk you through how to use each of these techniques to open up the VBE and allow you to start coding in VBA.

The video uses MS Excel 2010 but the same steps are used for MS Excel 2013 and Excel 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
----------------------------
Subscribe to Office Ninja: https://www.youtube.com/channel/UCY-6...
Understanding VBA Code playlist: https://www.youtube.com/watch?v=hLeU0...
Official Channel Series: https://www.youtube.com/watch?v=UDZ0r...

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/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/udemy

WiseOwl provides a lot of very good VBA tutorials: https://www.youtube.com/channel/UCbi5...
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.