Excel VBA Tutorials

• 1. Create a Macro
  • Swap Values
  • Run Code from a Module

• 2. Message Box
  • Input Box

• 3. Workbook and Worksheet Object
  • Loop through Books and Sheets
  • Sales Calculator

• 4. Range Object
  • CurrentRegion
  • Dynamic Range
  • Entire Rows and Columns
  • Offset
  • From Active Cell to Last Entry
  • Union and Intersect
  • Test a Selection
  • Possible Football Matches

• 5. Variables
  • Option Explicit
  • Variable Scope
  • Life of Variables

• 6. If-Then-Statement
  • Logical Operators
  • Select Case
  • Tax Rates
  • Mod Operator
  • Prime Number Checker
  • Find Second Highest Value

• 7. Loop
  • Loop through Defined Range
  • Loop through Entire Column
  • Do Until Loop
  • Step Keyword
  • Create a Pattern
  • Sort Numbers
  • Randomly Sort Data
  • Remove Duplicates
  • Complex Calculations
  • Knapsack Problem

• 8. Macro Errors
  • Debugging
  • Error Handling
  • Err Object

• 9. String Manipulation
  • Separate Strings
  • Reverse Strings

• 10. Date and Time
  • Compare Dates and Times
  • DateDiff Function

• 11. Events

• 12. Array
  • Dynamic Array
  • Array Function
  • Month Names
  • Size of an Array

• 13. Function and Sub
  • User Defined Function
  • Custom Average Function
  • Volatile Functions
  • ByRef and ByVal

• 14. Application Object
  • StatusBar
  • Read Data from Text File
  • Write Data to Text File

• 15. ActiveX-Controls

• 16. Userform