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
Contact the SuperExcelVBA team and check availability for consultancy and VBA In-Company classes.