Excel VBA Programming For Dummies, 3rd Edition

Excel VBA Programming For Dummies^®, 3rd Edition

Visit www.dummies.com/go/excelvbaprogrammingfd3e to view this book's cheat sheet.

Table of Contents

Introduction

Is This the Right Book?

So You Want to Be a Programmer. . . .

Why Bother?

What I Assume about You

Obligatory Typographical Conventions Section

Check Your Security Settings

How This Book Is Organized

Part I: Getting Started with Excel VBA Programming

Part II: How VBA Works with Excel

Part III: Programming Concepts

Part IV: Communicating with Your Users

Part V: Putting It All Together

Part VI: The Part of Tens

Icons Used in This Book

Getting the Sample Files

Now What?

Part I: Getting Started with Excel VBA Programming

Chapter 1: What Is VBA?

Okay, So What Is VBA?

What Can You Do with VBA?

Inserting a bunch of text

Automating a task you perform frequently

Automating repetitive operations

Creating a custom command

Creating a custom button

Developing new worksheet functions

Creating custom add-ins for Excel

Creating complete, macro-driven applications

Advantages and Disadvantages of VBA

VBA advantages

VBA disadvantages

VBA in a Nutshell

An Excursion into Versions

Chapter 2: Jumping Right In

First Things First

What You’ll Be Doing

Taking the First Steps

Recording the Macro

Testing the Macro

Examining the Macro

Modifying the Macro

Saving Workbooks That Contain Macros

Understanding Macro Security

More about the NameAndTime Macro

Part II: How VBA Works with Excel

Chapter 3: Working in the Visual Basic Editor

What Is the Visual ...