Choose your language

English Português

Free Excel VBA Course

Learn VBA and make your Excel productivity stand out...

Learn!
Tutorial VBA

Tutorial VBA

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

  1. Excel VBA: A description of the advantages and uses of Excel VBA
  2. VBA Settings: Environment settings to run Excel VBA
  3. VBA VBE: VBE, the VBA development IDE in Excel
  4. VBA Macro Recorder: Instructions for using the Excel macro recorder
  5. VBA First Macro: Excel VBA Hello World
  6. VBA Comments: How to make comments in Excel VBA
  7. VBA Buttons With Macro: Adding macros to buttons and shapes
  8. VBA Variables: Using and associating variables in Excel VBA
  9. VBA Operators: Arithmetic operators, text operators, and VBA comparison operators
  10. VBA If... Then: VBA If Then
  11. VBA Select Case: Select Case for Excel VBA
  12. VBA For Next: Loop For Next for Excel VBA
  13. VBA Do Loop: Do Loop of Excel VBA
  14. VBA Subroutine and Function: Subroutine and functions for Excel VBA
  15. VBA Strings: Text Functions in VBA
  16. VBA Events: Understanding VBA Events
  17. VBA Array: Using arrays in VBA
  18. VBA For Each: Using For Each loop in VBA
  19. VBA Range: Range in VBA
  20. VBA Named Range: Named Range in VBA
  21. VBA Select, Row, Column: Using Select, Row, and Column in VBA
  22. VBA Last row: Finding the Last Filled Row in VBA
  23. VBA Resize: Resizing Ranges Using VBA
  24. VBA Excel Formulas: Using Excel Formulas in VBA
  25. VBA UserForm: Using Excel Userform
  26. VBA UserForm Layout: Creating and adjusting the layout of the Excel UserForm
  27. VBA UserForm Event: Understanding UserForm Events
  28. VBA Worksheet Interface: Interacting the UserForm with the Worksheet
  29. VBA Error Handling: Handling VBA Errors
  30. VBA Libraries: Adding and Working with Libraries in VBA
  31. VBA Text Files: Working with text files (TXT and CSV)
  32. VBA Pivot Table: Using PivotTables with VBA
  33. VBA Email: Sending an email with VBA
  34. VBA Scheduled Execution: Scheduled Automation with VBA
Learn
Exercises VBA

Exercises VBA

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

  1. VBA Exercises: Exercises designed to help you learn VBA in an easy and practical way
  2. VBA Text Formatting: Simple VBA exercise that teaches you how to use the macro recorder and create useful codes
  3. VBA Color Selected: Simple vba exercise that teaches you to change the background color of selected cells
  4. VBA Metric Converter: VBA exercise to convert inches to centimeters
  5. VBA Do Loop Sum: Vba exercise that uses the Do Loop until a criterion is met
  6. VBA Sum of Powers: Simple vba exercise that teaches you to create a function that determines the limit of a series
  7. VBA Sort Array: Simple vba exercise that teaches you how to create a BubbleSort Algorithm
  8. VBA Simple Loop: Simple vba exercise that teaches to loop for next by binding the counter to the cell and the left function
  9. VBA Harmonic Mean: Simple vba exercise that teaches you to do a function to calculate the harmonic mean
  10. VBA Alternate Color: Simple vba exercise that teaches you to use two interlocking loops and color the cells
  11. VBA Even or Odd: Simple vba exercise that teaches you to sort data as even or odd
  12. VBA First Capital Letter: Vba exercise that teaches you to make the first capital letter of all the elements of a column
  13. VBA Intersection: Simple vba exercise that teaches you to use named Ranges and the intersect function
  14. VBA Ascending Order: Vba exercise that teaches you to change the order of a sequence for ascending
  15. VBA Concatenate: Simple vba exercise that teaches you to join data from different worksheets
  16. VBA Select Case: Vba exercise that teaches you to use the select case statement
  17. VBA Columns to Lines: Vba exercise that teaches you how to transform data that was in rows to columns
  18. VBA Making an Addition: Simple vba exercise that teaches you to use a loop to add data to a list with missing values
  19. VBA Offset Resize: Simple vba exercise that teaches you to use the Offset and Resize properties of the Range object
  20. VBA Search and Color: Vba exercise that teaches you to use loop along with the conditional If to color cells
  21. VBA Current Region: Simple vba exercise that teaches you to use the current region and formula R1C1
  22. VBA Simple Email: Vba exercise teaching you to send an automatic email
  23. VBA Message Box: An elaborate vba exercise that teaches you how to use msgbox and inputbox in an advanced way
  24. VBA Final Score: Vba exercise that teaches you to create a function to determine a mean with weights
  25. VBA Factorial Function: Simple vba exercise that teaches you to create a function that calculates the factorial value of a number
  26. VBA Infinite Series: Simple vba exercise that teaches you to use the loop until a criterion is met
  27. VBA Count dollar bills: Vba exercise that teaches you to fractionate a financial value to as few notes as possible
  28. VBA Prime Number: Vba exercise that teaches you to create a function to count the number of times a prime number appears
  29. VBA If Then Insert Cell: Vba exercise that teaches you to use loop along with conditional to insert cells
  30. VBA Text to Columns: Vba exercise that teaches you how to transform imported data into text form for columns
  31. VBA Even and Odd: Simple vba exercise that teaches you to sort data as even and odd
  32. VBA Ballot Box: Vba exercise that teaches you how to use User Form and create a voting booth for a company
  33. VBA Recursive Factorial: Vba exercise that teaches you how to create a recursive factorial function
  34. VBA Hangman Game: Vba exercise that teaches you how to create a Hangman game
  35. VBA HTML Email: Vba exercise that teaches to send an automatic email by exporting spreadsheet data in the form of an HTML table
Practice
VBA In-Company Courses

VBA In-Company Courses

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

See our services