4/2/2008 3:02:03 AM
VB vs. VBA
By Richard Rost
Q: I am not a programmer by nature. A while ago, I purchased VB 101. Basic stuff. My goal is to become "decent" with VBA. How different is it from straight VB? Will your new VB courses take me in that direction? - Lou
A: Lou, VBA is a close cousin of VB.
VB is a self-contained programming environment used for building standalone programs.
VBA is used with other programs (Visual Basic FOR APPLICATIONS) like Word, Excel, and Access.
My VB courses will teach you the VB language, plus specific controls for use with building programs. A good solid foundation in VB will help you to learn VBA, yes... but there is also a lot of extraneous material you might never need (as there is with any class you take).
If you want to learn VBA, you should study the VBA specific to the programs you want to work with. For example, I cover a LOT of VBA in my Microsoft Access 300-series of classes. It's VBA that's specific to Access.
I will also be covering VBA specific to Word, Excel, and even Outlook in those classes.
Hope that answers your question.
Keywords: vb vba access