Excel^? 2007 VBA Programming For Dummies^?

by John Walkenbach (J-Walk and Associates, Inc., San Diego, CA ); Revised by: Jan Karel Pieterse

• ISBN13: 9780470142363
• ISBN10: 0470142367
• Format: eBook
• Copyright: 2007-05-01
• Publisher: For Dummies

Summary

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 * 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

Table of Contents

Introduction

Introducing VBA

What Is VBA?

Jumping Right In

How VBA Works with Excel

Working In the Visual Basic Editor

Introducing the Excel Object Model

VBA Sub and Function Procedures

Using the Excel Macro Recorder

Programming Concepts

Essential VBA Language Elements

Working with Range Objects

Using VBA and Worksheet Functions

Controlling Program Flow and Making Decisions

Automatic Procedures and Events

Error -Handling Techniques

Bug Extermination Techniques

VBA Programming Examples

Communicating with Your Users

Simple Dialog Boxes

User Form Basics

Using User Form Controls

User Form Techniques and Tricks

Accessing Your Macros Through the User Interface

Putting It All Together

Creating Worksheet Functions and Living to Tell about It

Creating Excel Add-Ins

The Part of Tens

Ten VBA Questions (And Answers)

(Almost) Ten Excel Resources

Index

Table of Contents provided by Publisher. All Rights Reserved.