This Excel VBA Tutorial provides an introduction to Excel VBA (Visual Basic for Applications). Once you have mastered the VBA programming language, you will be able to produce macros to perform almost any task in Excel. You will soon discover that macros can save you hours of time, by automating repetitive tasks, and can interact with users to allow flexibility.
While this tutorial is by no means a comprehensive index of the VBA programming language, it does aim to 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 VBA programming books available.
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 prefer 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: Function & Sub Procedures
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
A further introduction to Excel VBA is provided on the Microsoft Office website.