- Shopping Bag ( 0 items )
First, you get well-acquainted with the most ...
First, you get well-acquainted with the most important tools and operations for the Visual Basic Editor; then, you get a quick overview of the essential elements and concepts for programming with Excel. Discover techniques for handling errors and exterminating bugs, the basics of working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes (also known as UserForms) and create custom toolbars and menus, you'll soon be creating the interfaces that best suit your unique needs.
By the time you rip through Excel 2000 Programming For Dummies, you'll not only have maximized your macros, you'll have moved on to creating Excel applications with the best programmers on the block.
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.