Table of Contents

Introduction.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 Sub and Function Procedures.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: UserForm Techniques and Tricks.Part V: Creating Custom Toolbars and Menus.Chapter 19: Customizing the Excel Toolbars.Chapter 20: When the Normal Excel Menus Aren't Good Enough.Part VI: Putting It All Together.Chapter 21: Creating Worksheet Functions - and Living to Tell about It.Chapter 22: Creating Excel Add-Ins.Chapter 23: Interacting with Other Office Applications.Part VII: The Part of Tens.Chapter 24: Ten VBA Questions (And Answers).Chapter 25: (Almost) Ten Excel Resources.Index.

About the Author

John Walkenbach is principal of J-Walk and Associates, Inc., a leading Excel expert, and proprietor of the popular spreadsheet page at www.j-walk.com. He has written more than 30 books on Excel.