Search results
Free Excel VBA Macros exercises. You are welcome to try any of the 52 exercises listed below, but please do not distribute them in any form without asking for our written permission first. Using Microsoft Excel to record macros to navigate round a maze.
- Recording Macros and Buttons
Excel VBA Macros: Topic: Recording macros and buttons:...
- Referencing Other Applications
This page lists the 2 exercises about Referencing other...
- Loops and Conditions
Use If statements in Excel VBA to validate a set of user...
- Functions Exercise
VBA training Create functions to turn feet/inches into...
- Messages and Variables Exercise
Excel VBA Macros (52 exercises) Topic ==> Messages and...
- Selecting Cells Exercise
VBA training Write macros to select various ranges...
- Recording Macros and Buttons
Start exercises. report error/feedback. Exercises designed to help you learn VBA in an easy and practical way.
Write a macro to put block arrow shapes into different cells for Little Red Riding Hood. Write a macro to generate all of the autoshapes in a worksheet. Draw car shapes using a macro, and use them to simulate a race. You can search our full list of VBA exercises here.
Practice Exercise. It's time to put the use of controls into practice with a small exercise. The file: controls-exercise.xlsm. Here is the starting point of the exercise: As you may have guessed, the goal is to fill in the table on the sheet using the form. Here are a few points to consider:
Enhance your Excel skills with this VBA practice test. Test your knowledge of Visual Basic for Applications in Excel.
These tutorials cover: Excel Formulas & Functions, VBA, and Keyboard Shortcuts. You will be asked to create a formula, use a shortcut, or type a line of VBA code directly into our web apps, receiving immediate feedback.
Excel VBA test. You are ready to start this test! It's free, anonymous and (we hope) fun. If after doing the test you'd like to take this further, we run a range of VBA training courses, both as classroom courses in the UK and online.