Excel VBA Macro Programming

Chapter List

Chapter 1: The Basics

Chapter 2: Variables, Arrays, Constants, and Data Types

Chapter 3: Modules, Functions, and Subroutines

Chapter 4: Programming Basics: Decisions and Looping

Chapter 5: Strings and Functions and Message Boxes

Chapter 6: Operators

Chapter 7: Debugging

Chapter 8: Errors and the Error Function

Chapter 9: Dialogs

Chapter 10: Common Dialog Control

Chapter 11: Command Bars and Buttons

In this part, you will learn all about how Visual Basic for Applications (VBA) works. You will learn rules for coding, how to write code, how to debug your codelooking for the inevitable errors that occurand how to build graphical user interfaces (GUIs) so that users can run your code easily. This is really all about the mechanics of code writing and is transferable to other Microsoft applications such as Access or Word.