Step-by-step instructions for creating VBA macros
Harness the power of VBA and create custom Excel applications
Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more. Discover how to
Table of Contents Introduction Part I: Introducing VBA.
- Grasp essential programming concepts
- Use the Visual Basic(r) Editor
- Navigate the new Excel user interface
- Communicate with your users
- Deal with errors and bugs
Chapter 1: What Is VBA? Part II: How VBA Works with Excel.
Chapter 2: Jumping Right In.
Chapter 3: Working In the Visual Basic Editor. Part III: Programming Concepts.
Chapter 4: Introducing the Excel Object Model.
Chapter 5: VBA Sub and Function Procedures.
Chapter 6: Using the Excel Macro Recorder.
Chapter 7: Essential VBA Language Elements. Part IV: Communicating with Your Users.
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.
Chapter 15: Simple Dialog Boxes. Part V: Putting It All Together.
Chapter 16: UserForm Basics.
Chapter 17: Using UserForm Controls.
Chapter 18: UserForm Techniques and Tricks.
Chapter 19: Accessing Your Macros Through the User Interface.
Chapter 20: Creating Worksheet Functions and Living to Tell about It. Part VI: The Part of Tens.
Chapter 21: Creating Excel Add-Ins.
Chapter 22: Ten VBA Questions (And Answers) Index
Chapter 23: (Almost) Ten Excel Resources.