About VBA in Excel
Throughout the site we will constantly refer to the offical VBA documentation through links. Getting used to reading such documentation will help you out in the long run, as well as keep us from a lot of rewriting. It may also often contain more in-depth documentation than what we have written as well.
The abbreviation VBA will mainly be used when referring to Visual Basics for Applications.
How to enable VBA in Excel
VBA is already included in Excel, so all we have to do is to enable its shortcut.
- Click on "File" and open the "Options" section in Excel.
- Go to the "Customize Ribbon" section and mark off for "Developer". Click "OK".
- The VBA editor is now available under the "Developer" tab.
Getting started with VBA in Excel
Since Visual Basic is the programming language used in all applications supporting VBA (e.g. Excel, PP, Word etc.), we have made a language introduction at Visual Basic language introduction.
There are a lot of great VBA tutorials online, so if you don't find what you're looking for in this wiki, check them out.
- Our guide Beginner tutorials on VBA in Excel.
- We found the Youtube tutorials by Tiger Spreadsheet Solutions to be both informative and understandable when first learning VBA.
Some useful information when coding can also be found at Tips and tricks for coding.
Useful tutorials
Our tutorials:
Our exercises:
External tutorials: