Page 14 - Excel Progamming Weekend Crash Course

540629 FM.qxd 9/2/03 4:10 PM Page xi

Contents at a Glance

FRIDAY.......................................................................................................2
PART I—Friday Evening ..........................................................................4
SESSION 1–Microsoft Excel Programming — Why and How ...................................5
SESSION 2–The VBA Code Editor ....................................................................17
SESSION 3–The Excel Object Model .................................................................31
SESSION 4–Syntax and Data in VBA ...............................................................47
SATURDAY ...............................................................................................66
PART II–Saturday Morning ...................................................................68
SESSION 5–Operators ....................................................................................69
SESSION 6–Control Constructs .......................................................................77
SESSION 7–Procedures and Modules ...............................................................87
SESSION 8–Working with Dates and Times ......................................................97
SESSION 9–Working with Text ......................................................................107
SESSION 10–Using Ranges and Selections ......................................................121
PART III–Saturday Afternoon ...........................................................140
SESSION 11–Working with Columns, Rows, and Cells .......................................141
SESSION 12–Programming with Custom Formulas ...........................................151
SESSION 13–Programming with Excel’s Built-In Functions ...............................161
SESSION 14–Formatting a Worksheet ............................................................171
SESSION 15–Find and Replace Operations ......................................................187
SESSION 16–Creating Custom Toolbars ..........................................................195
PART IV–Saturday Evening ................................................................208
SESSION 17–Introduction to Charts ..............................................................209
SESSION 18–Advanced Charting Techniques ...................................................225
SESSION 19–Creating Custom Dialog Boxes with User Forms .............................239
SESSION 20–Controls for User Forms .............................................................251