Put your acquired knowledge into practice by solving exercises with Excel VBA.
- VBA Exercises: Exercises designed to help you learn VBA in an easy and practical way
- 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 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 to loop for next by binding the counter to the cell and the left function
- 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 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 for 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 statement
- VBA Columns to Lines: Vba exercise that teaches you how to transform data that was in rows to columns
- 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 the Range object
- VBA Search and Color: Vba exercise that teaches you to use loop along with the conditional If to color 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
- VBA Message Box: An elaborate 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 notes 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 conditional to insert cells
- VBA Text to Columns: Vba exercise that teaches you how to transform imported data into text form for columns
- VBA Even and Odd: Simple vba exercise that teaches you to sort data as even and odd
- VBA Ballot Box: Vba exercise that teaches you how to use User Form and create a voting booth for a company
- 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.
