This Excel VBA Tutorial aims to introduce you to the basics of the Excel Visual Basic programming language. If you can master VBA programming, you can perform virtually any task you wish in your Excel file. You can produce macros that will interact with your users, perform automated responses to mouse clicks or other user actions, and save hours of time by performing a hundreds of actions within a few seconds - all at the click of a button!
While this tutorial is by no means a comprehensive index of all Visual Basic Excel commands and functionality, it should assist the beginner in getting started with writing Excel Macros, using VBA code. If you want to study Excel VBA programming in more depth, there are some excellent books available on the subject.
Click on the following links to view each stage of the Excel Visual Basic tutorial. It is advised that complete beginners start at the beginning and work through all stages of the tutorial, although those with some previous experience of VBA programming may want to dip into specific pages.
VBA Tutorial Part 1: Code Presentation
VBA Tutorial Part 2: Data Types, Variables and Constants
VBA Tutorial Part 3: Arrays
VBA Tutorial Part 4: Functions & Subroutines
VBA Tutorial Part 5: Conditional Statements
VBA Tutorial Part 6: Loops
VBA Tutorial Part 7: Operators and Built-In Functions
VBA Tutorial Part 8: The Excel Object Model
VBA Tutorial Part 9: Excel Events
VBA Tutorial Part 10: VBA Errors
View VBA Examples From the Tutorial
For those who wish to develop their VBA skills further, there is an excellent free Excel VBA Tutorial at the excel-vba.com website.