banner
VBA

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 VBA

to 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: