VBA Course: Introduction
VBA (Visual Basic for Applications) is a language similar to Visual Basic that requires a host application to run (Excel in our case).
Thanks to VBA we will be able to do just about anything we want with Excel...
But before we start, let's display the tools we will need.
Click on File Options Customize Ribbon then check Developer:
A new tab will be added:
If you are using a version of Excel earlier than 2007, add the Control Toolbox and Formulas toolbars.
To work with VBA code, we need an editor, this one is already installed and you can open it with the shortcut Alt + F11 (or by clicking on Visual Basic from the Developer tab):