Part I: Introducing VBA.

Chapter 1: What Is VBA?

Chapter 2: Jumping Right In.

Part II: How VBA Works with Excel.

Chapter 3: Introducing the Visual Basic Editor.

Chapter 4: Introducing the Excel Object Model.

Chapter 5: VBA Subroutines and Functions.

Chapter 6: Using the Excel Macro Recorder.

Part III: Programming Concepts.

Chapter 7: Essential VBA Language Elements.

Chapter 8: Working with Range Objects.

Chapter 9: Using VBA and Worksheet Functions.

Chapter 10: Controlling Program Flow and Making Decisions.

Chapter 11: Automatic Procedures and Events.

Chapter 12: Error-Handling Techniques.

Chapter 13: Bug Extermination Techniques.

Chapter 14: VBA Programming Examples.

Part IV: Developing Custom Dialog Boxes.

Chapter 15: Custom Dialog Box Alternatives.

Chapter 16: Custom Dialog Box Basics.

Chapter 17: Using Dialog Box Controls.

Chapter 18: Dialog Box Techniques and Tricks.

Part V: Creating Custom Toolbars and Menus.

Chapter 19: Customizing the Excel Toolbars.

Part VI: Putting It All Together.

Chapter 20: When the Normal Excel Menus Aren't Good Enough.

Chapter 21: Creating Worksheet Functions - and Living to Tell about It.

Chapter 22: Creating Excel Add-Ins.

Chapter 23: Creating Excel Applications for Others.

Part VII: The Part of Tens.

Chapter 24: Ten VBA Tips and Tricks.

Chapter 25: Ten VBA Questions (And Answers).

Chapter 26: Ten Excel Resources.