| 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 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 Functions and Excel 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.
Chapter 20: When Excel's Normal 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: Creating Excel Applications for Other Users.
PART VII: The Part of Tens.
Chapter 24: Top Ten VBA Tips and Tricks.
Chapter 25: Top Ten VBA Questions (And Answers).
Chapter 26: Top Ten Excel Resources.
Index.
|