Absolute Beginner's Guide to VBA

Cover......Page 1
Table of Contents......Page 5
Introduction......Page 14
I: Getting Started with VBA......Page 18
 1 Recording Your First Macro......Page 20
  What Is a Macro?......Page 21
  Recording a VBA Macro......Page 23
 2 Writing Your Own Macros......Page 28
  Displaying the Visual Basic Editor......Page 29
  Touring the Visual Basic Editor......Page 30
  Writing Your Own Command Macro......Page 31
  Running a VBA Macro......Page 33
  Creating User-Defined Functions with VBA......Page 34
  Working with Procedures......Page 36
  Working with Modules......Page 44
  Shutting Down the Visual Basic Editor......Page 45
 3 Understanding Program Variables......Page 48
  Declaring Variables......Page 49
  Avoiding Variable Errors......Page 50
  Variable Data Types......Page 51
  Using Array Variables......Page 53
  Working with Constants......Page 54
 4 Building VBA Expressions......Page 56
  Working with VBA Operators......Page 58
  Understanding Operator Precedence......Page 61
  Working with Numeric Expressions......Page 64
  Working with String Expressions......Page 67
  Working with Logical Expressions......Page 70
  Working with Date Expressions......Page 71
 5 Working with Objects......Page 76
  Working with Object Properties......Page 78
  Working with Object Methods......Page 81
  Handling Object Events......Page 83
  Working with Object Collections......Page 84
  The Is Operator......Page 85
  Working with Multiple Properties or Methods......Page 86
  Example: The Application Object......Page 88
  Example: The Window Object......Page 91
 6 Controlling Your VBA Code......Page 96
  Using If...Then to Make True/False Decisions......Page 97
  Using If...Then...Else to Handle a False Result......Page 99
  Making Multiple Decisions......Page 100
  Functions That Make Decisions......Page 108
  Using Do...Loop Structures......Page 112
  Using For...Next Loops......Page 114
  Using For Each...Next Loops......Page 116
  Using Exit For or Exit Do to Exit a Loop......Page 118
II: Putting VBA to Work......Page 122
 7 Programming Word......Page 124
  Working with Documents......Page 125
  The Range Object......Page 136
  The Selection Object......Page 140
  The Characters Object......Page 144
  The Words Object......Page 145
  The Paragraph Object......Page 147
 8 Programming Excel......Page 150
  Excel’s Application Object......Page 151
  Manipulating Workbook Objects......Page 158
  Dealing with Worksheet Objects......Page 162
  Working with Range Objects......Page 164
 9 Programming PowerPoint......Page 176
  PowerPoint’s Presentation Object......Page 177
  Working with PowerPoint Slide Objects......Page 183
  Dealing with Shape Objects......Page 187
  Operating a Slide Show......Page 200
 10 Programming Access Databases......Page 204
  Getting Ready: Two Steps Before You Begin......Page 205
  Working with Database Records: Opening a Recordset......Page 207
  Working with a Recordset......Page 213
  Retrieving Data into Excel......Page 224
 11 Programming Outlook Email......Page 232
  Working with Outlook Folders......Page 233
  Working with Email Messages......Page 237
  Sending a Message......Page 241
  Working with Attachments......Page 244
  Programming Outlook from Other Applications......Page 246
III: Getting the Most Out of VBA......Page 252
 12 Interacting with the User......Page 254
  Programming Sounds......Page 255
  Displaying Information to the User......Page 256
  Getting Input from the User......Page 267
 13 Creating Custom VBA Dialog Boxes......Page 276
  Adding a Form to Your Project......Page 277
  Changing the Form’s Design-Time Properties......Page 278
  Working with Controls......Page 281
  Handling Form Events......Page 287
  Types of Form Controls......Page 288
  Using a Form in a Procedure......Page 298
 14 Creating Custom Menus and Toolbars......Page 304
  Assigning Macros to Menu Commands......Page 305
  Creating Custom Toolbars for Your Macros......Page 309
  Menus, Toolbars, and VBA......Page 310
  Understanding Command Bars......Page 311
  Working with Command Bar Controls......Page 319
 15 Debugging VBA Procedures......Page 328
  A Basic Strategy for Debugging......Page 329
  Pausing a Procedure......Page 342
  Stepping Through a Procedure......Page 345
  Monitoring Procedure Values......Page 347
  Using the Immediate Window......Page 351
  Debugging Tips......Page 354
IV: Appendixes......Page 358
 A: VBA Statements......Page 360
 B: VBA Functions......Page 366
 B......Page 376
 D......Page 377
 E......Page 378
 I......Page 379
 M......Page 380
 O......Page 381
 P......Page 382
 S......Page 383
 U......Page 384
 W-Z......Page 385