Skip to Main Content
Excel 2003 VBA Programmer's Reference
book

Excel 2003 VBA Programmer's Reference

by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg
July 2004
Beginner content levelBeginner
1176 pages
27h 45m
English
Wrox
Content preview from Excel 2003 VBA Programmer's Reference

Contents

About the Authors

Acknowledgments

Introduction

Chapter 1: Primer in Excel VBA

Using the Macro Recorder

Recording Macros

Running Macros

The Visual Basic Editor

Other Ways to Run Macros

User Defined Functions

Creating a UDF

What UDFs Cannot Do

The Excel Object Model

Objects

Getting Help

Experimenting in the Immediate Window

The VBA Language

Basic Input and Output

Calling Functions and Subroutines

Variable Declaration

Scope and Lifetime of Variables

Variable Type

Object Variables

Making Decisions

Looping

Arrays

Runtime Error Handling

Summary

Chapter 2: Programming in the VBE

Writing Code

Programming for People

Writing Code

Where Does My Code Go?

Managing a Project

Adding Classes

Modifying Properties

Importing and Exporting Visual Basic Code

Editing

Managing Editor Options

Running and Debugging Code

Using Watches

Using the Object Browser

Summary

Chapter 3: The Application Object

Globals

The Active Properties

Display Alerts

Screen Updating

Evaluate

InputBox

StatusBar

SendKeys

OnTime

OnKey

Worksheet Functions

Caller

Summary

Chapter 4: Object-Oriented Theory and VBA

Comparing Classes and Interfaces

Defining an Interface

Implementing an Interface

Defining Methods

Parameters

Implementing Recursive Methods

Eliminating Recursion with Loops

Defining Fields

Defining Properties

Read-Only Properties

Write-Only Properties

Defining Events

Defining Events in Classes

Raising Events

Handling Events

Information Hiding and Access Modifiers

Encapsulation, Aggregation, and References

Summary ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2007 VBA Programming with XML and ASP

Excel 2007 VBA Programming with XML and ASP

Julitta Korol
Microsoft® Office Excel 2003 Programming Inside Out

Microsoft® Office Excel 2003 Programming Inside Out

Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Access™ 2007 VBA Programmer's Reference

Access™ 2007 VBA Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein

Publisher Resources

ISBN: 9780764556609Purchase book