Page 5 - Microsoft Office Excel 2003 Programming Inside Out

Contents at a Glance

Part 1
Part 4
Preliminaries 1€ Advanced VBA 191€

Chapter 1
Chapter 9
What’s New in Excel 2003 . . . . . . . 3
Manipulating Data with VBA. . . . 193

Chapter 2
Chapter 10
Exploring Excel . . . . . . . . . . . . . . 13
Formatting Excel Objects . . . . . . 219

Part 2
Chapter 11
Visual Basic € Creating Add-Ins and
COM Add-Ins . . . . . . . . . . . . . . . 239
for Applications 23€
Chapter 12
Chapter 3
Understanding and
Exploring Visual Basic
Using Events . . . . . . . . . . . . . . . 265
for Applications . . . . . . . . . . . . . . 25
Chapter 13
Chapter 4
Manipulating Files . . . . . . . . . . . 281
VBA Programming Starter Kit . . . . 41
Chapter 14
Chapter 5
Developing Class Modules . . . . . 299
Creating Sub and
Function Procedures. . . . . . . . . . . 85
Part 5
Manipulating €
Part 3
Excel Objects 319€
The Excel €
Object Model 105€ Chapter 15
Charts. . . . . . . . . . . . . . . . . . . . 321
Chapter 6
The Application Object . . . . . . . . 107
Chapter 16
PivotTables and PivotCharts. . . . 341
Chapter 7
Workbooks and Worksheets . . . . 129
Chapter 17
Command Bars . . . . . . . . . . . . . 365
Chapter 8
Ranges and Cells . . . . . . . . . . . . 161
Chapter 18
Customizing Dialog Boxes . . . . . 383

v