VBA, which stands for Visual Basic for Applications, is a programming language
developed by Microsoft. Excel, along with the other members of Microsoft Office family
includes the VBA language. In a nutshell, VBA is the tool that people use to develop
programs that control Excel (and other programs in the Office suite).
Don't confuse VBA with VB (which stands for Visual Basic). VB is a programming language that lets you create standalone executable programs (those .EXE files). Although VBA and VB have a lot in common, they are quite different.
You are probably aware that Excel is used for many of different tasks. By using VBA you can make Excel or the other programs do exactly what you want automatically. VBA works behind the scenes using functions and subroutines like any other programming language, but with a familiar interface such as MS Word or MS Excel
Here are some tips for getting started with VBAto access the code window goto to the developer tab from the menu bar options: Create a new module by right clicking in the project window: