This tutorial is an introduction to the Excel VBA (Visual Basic for Applications) programming language. After learning VBA, you will be able to create macros and perform almost any task in Excel. You will soon realize that macros can save you a lot of time by automating repetitive tasks and allowing you to interact with other users in a flexible manner.
This tutorial is not intended to be a comprehensive guide to the Excel VBA programming language. Its purpose is to help a beginner learn how to write macros in Excel using VBA code. For those who want to learn this programming language in more depth, there are excellent books on Excel VBA. The following is the contents of the Excel Visual Basic Tutorial. For novice programmers, it is highly recommended to start with the first section of the tutorial and study them in order. Those with experience in VBA programming can jump straight to topics of interest.
- Part 1: Code Formatting
- Part 2: Data types, variables and constants
- Part 3: Arrays
- Part 4: Function and Sub Procedures
- Part 5: Conditional statements
- Part 6: Cycles
- Part 7: Operators and built-in functions
- Part 8: Excel Object Model
- Part 9: Events in Excel
- Part 10: VBA Errors
- VBA examples
A more detailed description of Excel VBA can be found on the Microsoft Office website.