Choose your language

VBA Exercises

Why should I do VBA exercises?

Exercising is a great way to learn and retain content in a practical way.

Just like a new language, to create fluency in tongue you have to practice. With this, it will become more and more intuitive how to use the concepts in the corporate day-to-day.

This exercise section was divided into Basic, Intermediate, Advanced to guide you through the learning process in the most didactic way, with progressive challenges.

Microsoft Visual Basic for Applications® has a help function. To use it simply place the cursor over the part of the code that you are having difficulty and press

Enabling macros

Remember to accept the security warning in the Message Bar on the top of the plan to enable macros. If you desire to keep macros always enabled see VBA Enabling Macros.

Keep in mind that there are several different ways to solve an exercise. The solution suggested by SuperExcelVBA® aims to prioritize learning and to aid you to develop your expertise with the code and may not be the most efficient solution

This content was created with Excel 2016.

INTRODUCTION

VBA Exercises

BASIC

VBA Formatting Text VBA Color Selected VBA Metric Converter VBA Do Loop Sum VBA Sum of Powers VBA Sort Array VBA Simple Loop VBA Harmonic Mean VBA Alternate Color VBA Even or Odd VBA First Capital Letter VBA Intersection VBA Ascending Order VBA Concatenate VBA Select Case VBA Columns to Lines VBA Making an Addition VBA Offset Resize VBA Search and Color VBA Current Region VBA Simple Email

INTERMEDIATE

VBA Message Box VBA Final Score VBA Factorial Function VBA Infinite Series VBA Count dollar bills VBA Prime Number VBA If Insert Cell VBA Text to Columns VBA Even and Odd VBA Ballot Box

ADVANCED

VBA Recursive Factorial VBA Hangman Game VBA HTML Email

SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2024 SuperExcelVBA | ABOUT

Protected by Copyscape