I was in a similar situation to you a couple of years ago and one thing that threw me initially is that VB (Visual Basic) is not the same as VBA (Visual Basic for Applications).
VB = standalone programming language
VBA = programming language built into Excel, Word etc.
In my case I wanted...