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.




Bilderesultat for visual basic for applications logoBilderesultat for excel logo




How to enable VBA in Excel

VBA is already included in Excel, so all we have to do is to enable its shortcut.

  1. Click on "File" and open the "Options" section in Excel.
  2. Go to the "Customize Ribbon" section and mark off for "Developer". Click "OK".


  3. 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.

Some useful information when coding can also be found at Tips and tricks for coding.



Useful tutorials

Our tutorials:

Our exercises:

External tutorials: