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:

ribbon introduction

A new tab will be added:

dev introduction

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

vbe png introduction

We will come back to this, simply remember the shortcut Alt + F11 for the moment...