Excel VBA Projects for Practice: 7 Exercises

Get FREE Advanced Excel Exercises with Solutions!

This article will provide you with seven Excel VBA projects for practice. One with advanced knowledge of Excel should be able to solve all problems with ease. You need to know the following topics to solve the problems: count colored cells, clear the contents of specific cells, create a digital clock, display all possible permutations, send email following a list, spell dollar amounts to words, prepare a simple calculator, and use VBA textbox datepicker. Additionally, you should know how to make VBA code faster and enable the developer tab. Excel 2013 or later versions will be enough to solve the problems.


Download Practice Workbook

You can download the Excel file from the following link.


Problem Overview

There are seven exercises related to the Excel VBA projects for practice. Each of them has a distinct dataset. The exercises are provided in the “Problem” sheet, and the solutions to those are in the “Solution” sheet. In addition, this article’s introduction lists the problems’ solutions in order. The first exercise is shown in the following picture.

Problem Overview

Let’s go through the exercises for this article.

  • Project 01: Spell Dollar Amount in Words
    • Twenty dollar amounts are given. Your task is to spell the amount in words using a custom VBA function.
  • Project 02: Send Email to a List of Recipients
    • The second project is to send the exact email to a list of people. The email will be on the BCC field of the Outlook application.
  • Project 03: Create a Basic Calculator
    • You will create a simple calculator, where a user will input two numbers. Then, he or she will press any of the four common operation buttons (addition, subtraction, multiplication, and divide) and it will be shown in an output cell. Additionally, create a button to clear the cell contents.
  • Project 04: Prepare a Digital Clock
    • In this exercise, your task is to create a digital clock using the VBA code. There will be two buttons. The first one will start the clock, and the other will stop the clock.
  • Project 05: Display All Possible Permutations
    • Create a VBA code to show all the possible permutations of a four digit string. You will input the value in cell D76 and then the output will be shown in the cell range B70:B93.
  • Project 06: Count Cells by Fill Color
    • Marks of twenty students are provided. Your task is to create a VBA code to create a custom function to count the lime colored cells.
  • Project 07: Create VBA Date Picker
    • In this exercise, you will create a date picker using the UserForm. Then, return the value in the cell B125.

The following animated image shows a custom function to count cells by the fill color.

Finally, the image below depicts the solution to the first exercise.

Excel VBA Projects for Practice


Conclusion

Thank you for reading this article. We hope you have learned more about Excel VBA projects for practice by completing these exercises. You can find more articles similar to this on the ExcelDemy website. If you have any questions or suggestions, feel free to comment below. However, remember that our website implements comment moderation. Therefore, your comment may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Keep excelling!

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo