Learn how to create macros in VBA, automate tasks in Excel, and be more productive at work.

- Excel VBA: Advantages and uses of Excel VBA
- VBA Settings: Environment settings to run Excel VBA
- VBA VBE: VBE, the VBA development IDE in Excel
- VBA Macro Recorder: Instructions for using the Excel macro recorder
- VBA First Macro: Excel VBA Hello World
- VBA Comments: How to make comments in Excel VBA
- VBA Buttons With Macro: Adding macros to buttons and shapes

- VBA Variables: Using and associating variables in Excel VBA
- VBA Operators: Arithmetic operators, text operators, and VBA comparison operators
- VBA If... Then: VBA If Then conditional statements
- VBA Select Case: Select Case statements for Excel VBA
- VBA For Next: Loop For Next for Excel VBA
- VBA Do Loop: Do Loop statements of Excel VBA
- VBA Subroutine and Function: Subroutine and functions for Excel VBA
- VBA Strings: Main text Functions in VBA
- VBA Events: Understanding VBA Events
- VBA Array: Using arrays in VBA
- VBA For Each: Using For Each loop in VBA

- VBA Range: Range statement in VBA
- VBA Named Range: Named Range in VBA
- VBA Select, Row, Column: Using Select, Row, and Column in VBA
- VBA Last row: Finding the last filled row in VBA
- VBA Resize: Resizing Ranges using VBA
- VBA Excel Formulas: Using Excel Formulas in VBA

- VBA UserForm: Using Excel Userform
- VBA UserForm Layout: Creating and adjusting the layout of the Excel UserForm
- VBA UserForm Event: Understanding UserForm Events
- VBA Worksheet Interface: Interfacing the UserForm with the Worksheet

- VBA Error Handling: Handling VBA Errors
- VBA Libraries: Adding and Working with Libraries in VBA
- VBA Text Files: Working with text files (TXT and CSV)
- VBA Pivot Table: Using PivotTables with VBA
- VBA Email: Sending an email with VBA
- VBA Scheduled Execution: Scheduled automation with VBA

Put your acquired knowledge into practice by solving exercises with Excel VBA.

- 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

- 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

- 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.

- SuperExcelVBA Team: The team behind SuperExcelVBA
- Contact SuperExcelVBA: Contact SuperExcelVBA Team