In this article you will read more about the Microsoft Office program VBA. It explains what VBA is, what you can use it for and within which levels challenges are offered.

VBA stands for Visual Basic for Application and is the programming language for creating applications in Excel. VBA is a powerful tool for automating time-consuming and repetitive tasks.

For an overview of all VBA-challenges, first go to the Library.

The Library can be found by clicking on Library in the upper right corner of the tool.

Then click on VBA at the top left of all programs to see the range of VBA tracks and challenges available.

Make sure you have the Language setting of that page (top right) set to English. There are currently no VBA-challenges in Dutch. You can also set the filter to German if you want to do a Beginner track VBA. We are working hard to offer the VBA-challenges in Dutch as well.

VBA is mainly used in the business field to use powerful functions of Excel in your own custom programs. Tasks in VBA are performed faster than if you do it manually in Excel. You save a lot of time with this, allowing you to work in a very efficient way. Writing the codes is something you must learn first, but you can master this with 5miles.

To get started with VBA, you learn through the Standard Curriculum. In total, you can do three different VBA tracks: a beginner track and two intermediate (intermediate) level tracks.

If you have never done anything with VBA before, it is recommended that you start with this track. The track contains 31 challenges that will help you master the basics of VBA for creating macros and automatic processes in Excel.

The two tracks of intermediate (intermediate) level VBA will help you further along the way to improve your skills in automating scripts. The first track consists of 30 challenges and the second consists of nine challenges.

Have you ever worked with VBA but do not know at what level you want to start?

At the bottom of the overview of VBA in the Library it says: 'Find it difficult to determine your current skill level? Click here to do a short assessment and we will recommend a level that suits you best.' When you click 'here', a small window opens asking three questions.

It is important that you do not start guessing, as this can lead to you 'accidentally' getting a question right and being recommended a too high level. If you don´tt know the answer to a question, just click that you don't know. At the end, a track is recommended on which you can start. Does it seem too high/low to you? You are not stuck to anything and can always switch.

Do you notice during the track that the level does not suit you? Read in this article how you can switch tracks.