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

Contact the SuperExcelVBA team and check availability for consultancy and VBA In-Company classes.

- SuperExcelVBA Team: The team behind SuperExcelVBA
- Courses and Consulting SuperExcelVBA: Courses and Consulting conducted by the SuperExcelVBA team
- Contact SuperExcelVBA: Contact SuperExcelVBA Team