Learn how to create macros in VBA, automate tasks in Excel, and be more productive at work.
Put your acquired knowledge into practice by solving exercises with Excel VBA.
Basic
- VBA Text Formatting: Simple VBA exercise that teaches you how to use the macro recorder and create useful codes
- VBA Color Selected: Simple VBA exercise that teaches you how to change the background color of selected cells
- VBA Metric Converter: VBA exercise to convert inches to centimeters
- VBA Do Loop Sum: VBA exercise that uses the Do Loop until a criterion is met
- VBA Sum of Powers: Simple VBA exercise that teaches you to create a function that determines the limit of a series
- VBA Sort Array: Simple VBA exercise that teaches you how to create a BubbleSort Algorithm
- VBA Simple Loop: Simple VBA exercise that teaches you how to use concatenation in a loop
- VBA Harmonic Mean: Simple VBA exercise that teaches you to do a function to calculate the harmonic mean
- VBA Alternate Color: Simple VBA exercise that teaches you to use two interlocking loops and fill with color the cells
- VBA Even or Odd: Simple VBA exercise that teaches you to sort data as even or odd
- VBA First Capital Letter: VBA exercise that teaches you to make the first capital letter of all the elements of a column
- VBA Intersection: Simple VBA exercise that teaches you to use named Ranges and the Intersect function
- VBA Ascending Order: VBA exercise that teaches you to change the order of a sequence to ascending
- VBA Concatenate: Simple VBA exercise that teaches you to join data from different worksheets
- VBA Select Case: VBA exercise that teaches you to use the Select Case statements
- VBA Columns to Lines: VBA exercise that teaches you how to transform data that was in columns to rows
- VBA Making an Addition: Simple VBA exercise that teaches you to use a loop to add data to a list with missing values
- VBA Offset Resize: Simple VBA exercise that teaches you to use the Offset and Resize properties of a Range object
- VBA Search and Color: VBA exercise that teaches you to use loop along with the conditional If to fill cells
- VBA Current Region: Simple VBA exercise that teaches you to use the Current Region and formula R1C1
- VBA Simple Email: VBA exercise teaching you to send an automatic email
Intermediate
- VBA Message Box: VBA exercise that teaches you how to use MsgBox and InputBox in an advanced way
- VBA Final Score: VBA exercise that teaches you to create a function to determine a mean with weights
- VBA Factorial Function: Simple VBA exercise that teaches you to create a function that calculates the factorial value of a number
- VBA Infinite Series: Simple VBA exercise that teaches you to use the loop until a criterion is met
- VBA Count dollar bills: VBA exercise that teaches you to fractionate a financial value to as few bills as possible
- VBA Prime Number: VBA exercise that teaches you to create a function to count the number of times a prime number appears
- VBA If Then Insert Cell: VBA exercise that teaches you to use loop along with a conditional to insert cells
- VBA Text to Columns: VBA exercise that teaches you how to transform imported text data into columns
- VBA Even and Odd: Simple VBA exercise that teaches you to organize data when even or odd
- VBA Ballot Box: VBA exercise that teaches you how to use UserForm and create a voting booth for a company
Advanced
- VBA Recursive Factorial: VBA exercise that teaches you how to create a recursive factorial function
- VBA Hangman Game: VBA exercise that teaches you how to create a Hangman game
- VBA HTML Email: VBA exercise that teaches to send an automatic email by exporting spreadsheet data in the form of an HTML table
Feel free to contact the SuperExcelVBA team.