Understanding Visual Basic for Applications (VBA)

When you record a Macro, your recorded steps are being converted into VBA or…what's called Visual Basic for Applications.…The more you work with Macros, the more important it becomes to understand…what's going on behind the scenes and understanding a little of the terminology…and concepts in this wonderful world of VBA.…Let's see what's really being recorded when we're creating our Macros.…I am going to switch over to Word, from Word I'll press Alt F11 on my keyboard,…and that toggles back to the Microsoft Visual Basic for Applications screen or…what we call the VBA Editor.…

And this is what you created, if you're following along of course, this is VBA,…a subset of Microsoft Visual Basic.…The main difference between the two is that VBA must be run from a host…application as it is here in Word.…You can also use a VBA Editor in other applications such as Excel,…PowerPoint, and Outlook.…As a matter of fact, there are two different VBA courses here in the Lynda.com…Library, one for VBA in Excel and the other one is for Access.…