Microsoft Office (VBA)

Introducing the Visual Basic Editor - Page 23
Accessing Visual Basic Editor (VBE) - Page 24
Touring the VBE Toolbar - Page 25
Touring the VBE Toolbar - Page 26
Setting VBE Options - Page 27
Using Project Explorer - Page 28
Understanding VBA Project - Page 29
Working with Modules - Page 30
Working with Modules - Page 31
Using the Main Code Window - Page 32
Using the Main Code Window - Page 33
Protecting Your Projects - Page 34
Excel Procedures - Page 35
Excel Procedures - Page 36
Saving a Workbook as Today's Date - Page 37
Saving a Workbook as Today's Date - Page 38
Highlighting Duplicates Within a Range - Page 39
Highlighting Duplicates Within a Range - Page 40
Sorting Worksheets - Page 41
Sorting Worksheets - Page 42
Generating a Unique List - Page 43
Generating a Unique List - Page 44
Generating a Unique List - Page 45
Using AutoFilter on a Protected Sheet - Page 46
Deleting Rows Based on Criteria - Page 47
Deleting Rows Based on Criteria - Page 48
Deleting Rows Based on Criteria - Page 49
Deleting Rows Based on Criteria - Page 50
Checking Whether or Not a File Exists - Page 51
Removing Hyperlinks - Page 52
Applying SUM / COUNT by Color - Page 53
Applying SUM / COUNT by Color - Page 54
Applying SUM / COUNT by Color - Page 55
Using More Than Three Conditional Formats - Page 56
Using More Than Three Conditional Formats - Page 57
Providing a Calendar to Choose Dates for Input - Page 58
Providing a Calendar to Choose Dates for Input - Page 59
Providing a Calendar to Choose Dates for Input - Page 60
Restricting Text Box Entry to Numbers - Page 61
Restricting Text Box Entry to Numbers - Page 62
Running a Macro When a Cell Changes - Page 63
Running a Macro When a Cell Changes - Page 64
Forcing the Use of a Custom Print Procedure - Page 65
Restricting the User to a Portion of the Worksheet - Page 66
Restricting the User to a Portion of the Worksheet - Page 67
Copying a Workbook with Macros Removed - Page 68
Copying a Workbook with Macros Removed - Page 69
Inserting Empty Rows in a Range - Page 70
Inserting Empty Rows in a Range - Page 71
Creating a Custom Toolbar - Page 72
Creating a Custom Toolbar - Page 73
Creating a Custom Toolbar - Page 74
Creating a Custom Toolbar - Page 75
Creating a Table of Contents of a Workbook - Page 76
Creating a Table of Contents of a Workbook - Page 77
Changing the Case of Text - Page 78
Changing the Case of Text - Page 79
Creating a Photo Album - Page 80
Creating a Photo Album - Page 81
Creating a Photo Album - Page 82
Deleting the Empty Rows in a Range - Page 83
Deleting the Empty Rows in a Range - Page 84
Creating a List of Files That Reside in a Directory - Page 85
Creating a List of Files That Reside in a Directory - Page 86
Creating a List of Files That Reside in a Directory - Page 87
Creating a List of Files That Reside in a Directory - Page 88
Forcing the User to Enable Macros - Page 89
Forcing the User to Enable Macros - Page 90
Finding and Replacing a String in All Open Workbooks - Page 91
Converting Data to a Tabular Format - Page 92
Converting Data to a Tabular Format - Page 93
Converting Data to a Tabular Format - Page 94
AutoNumbering Invoices and Other Workbooks - Page 95
Comparing Columns Using Various Criteria - Page 96
Comparing Columns Using Various Criteria - Page 97
Comparing Columns Using Various Criteria - Page 98
Deleting the Contents of Unlocked Cells - Page 99
Deleting the Contents of Unlocked Cells - Page 100
Hiding All Standard Toolbars Except Your Own - Page 101
Hiding All Standard Toolbars Except Your Own - Page 102
Hiding All Standard Toolbars Except Your Own - Page 103
Creating a PPT Presentation from a Pivot Chart - Page 104
Creating a PPT Presentation from a Pivot Chart - Page 105
Creating a PPT Presentation from a Pivot Chart - Page 106
Creating a PPT Presentation from a Pivot Chart - Page 107
Creating a PPT Presentation from a Pivot Chart - Page 108
Saving a Backup Copy of a Workbook - Page 109
Saving a Backup Copy of a Workbook - Page 110
Saving a Backup Copy of a Workbook - Page 111
Importing Your Contacts from Outlook - Page 112
Importing Your Contacts from Outlook - Page 113
Importing Your Contacts from Outlook - Page 114
E-mailing from Excel with Outlook - Page 115
E-mailing from Excel with Outlook - Page 116
E-mailing from Excel with Outlook - Page 117
Printing a UserForm - Page 118
Printing a UserForm - Page 119
Printing a UserForm - Page 120
Importing and Formatting a Text File - Page 121
Importing and Formatting a Text File - Page 122
Importing and Formatting a Text File - Page 123
Importing and Formatting a Text File - Page 124
Extracting Numbers from a Text String - Page 125
Extracting Numbers from a Text String - Page 126
Finding and Deleting Erroneously Named Ranges - Page 127
Finding and Deleting Erroneously Named Ranges - Page 128
Logging Actions When a Cell Changes - Page 129
Logging Actions When a Cell Changes - Page 130
Logging Actions When a Cell Changes - Page 131
Synchronizing Page Fields of Pivot Tables - Page 132
Synchronizing Page Fields of Pivot Tables - Page 133
Synchronizing Page Fields of Pivot Tables - Page 134
Word Procedures - Page 135
Word Procedures - Page 136
Word Procedures - Page 137
Finding and Replacing in Multiple Documents - Page 138
Finding and Replacing in Multiple Documents - Page 139
Finding and Replacing in Multiple Documents - Page 140
Finding and Replacing in Multiple Documents - Page 141
Highlighting a Selection - Page 142
Highlighting a Selection in Word 2002/XP - Page 143
Highlighting a Selection in Word 2002/XP - Page 144
Removing All Highlighting - Page 145
Inserting AutoText with No Formatting - Page 146
Updating All Fields - Page 147
Setting Hyperlinks on Index Entries - Page 148
Setting Hyperlinks on Index Entries - Page 149
Setting Hyperlinks on Index Entries - Page 150
Setting Hyperlinks on Index Entries - Page 151
Setting Hyperlinks on Index Entries - Page 152
Setting Hyperlinks on Index Entries - Page 153
Displaying a Number in Millions as Text - Page 154
Displaying a Number in Millions as Text - Page 155
Displaying a Number in Millions as Text - Page 156
Copying Nested Field Codes as Text - Page 157
Copying Nested Field Codes as Text - Page 158
Copying Nested Field Codes as Text - Page 159
Converting AutoNumbered Text into Normal Text - Page 160
Converting AutoNumbered Text into Normal Text - Page 161
Tables: Changing the Tab Direction - Page 162
Tables: Changing the Tab Direction - Page 163
Tables: Suppressing New Rows When Tabbing - Page 164
Tables: Formatting Numbers in a Selection - Page 165
Tables: Formatting Numbers in a Selection - Page 166
Tables: Copying Formulas - Page 167
Tables: Copying Formulas - Page 168
Tables: Copying Formulas - Page 169
Tables: Copying Formulas - Page 170
Tables: Copying Formulas - Page 171
Tables: Copying Formulas - Page 172
Using Calendar Wizard - Page 173
Using Calendar Wizard - Page 174
Using Calendar Wizard - Page 175
Using Calendar Wizard - Page 176
Using Calendar Wizard - Page 177
Using Calendar Wizard - Page 178
Formatting Your Calendar - Page 179
Changing the Borders - Page 180
Changing the Borders - Page 181
Changing the Borders - Page 182
Changing the Borders - Page 183
Making Changes - Page 184
Controlling the Picture Size - Page 185
Changing the Path for Graphics Files - Page 186
Changing the Path for Graphics Files - Page 187
Changing the Path for Graphics Files - Page 188
Changing the Path for Graphics Files - Page 189
Changing the Path for Graphics Files - Page 190
Forms: Suppressing New Paragraphs in Form Fields - Page 191
Forms: Suppressing New Paragraphs in Form Fields - Page 192
Forms: Suppressing New Paragraphs in Form Fields - Page 193
Forms: Formatting Text Input in Form Fields - Page 194
Forms: Formatting Text Input in Form Fields - Page 195
Forms: Formatting Text Input in Form Fields - Page 196
Forms: Formatting Text Input in Form Fields - Page 197
Changing Other Types of Formatting - Page 198
Forms: Inserting a New Table Row - Page 199
Forms: Inserting a New Table Row - Page 200
Forms: Inserting a New Table Row - Page 201
Forms: Inserting a New Table Row - Page 202
Forms: Inserting a New Table Row - Page 203
Forms: Inserting a New Table Row - Page 204
Forms: Deleting a Table Row - Page 205
Forms: Deleting a Table Row - Page 206
Forms: Deleting a Table Row - Page 207
Forms: Deleting a Table Row - Page 208
Forms: Placing a Picture in a Protected Form - Page 209
Forms: Placing a Picture in a Protected Form - Page 210
Mail Merge: Using a Relative Path for Data Source - Page 211
Mail Merge: Using a Relative Path for Data Source - Page 212
Mail Merge: Using a Relative Path for Data Source - Page 213
Mail Merge: Displaying the Mail Merge Interface - Page 214
Mail Merge: Displaying the Mail Merge Interface - Page 215
Mail Merge: Creating a User-Friendly List of Fields - Page 216
Mail Merge: Creating a User-Friendly List of Fields - Page 217
Mail Merge: Creating a User-Friendly List of Fields - Page 218
Mail Merge: Making Placecards Using WordArt - Page 219
Mail Merge: Making Placecards Using WordArt - Page 220
Mail Merge: Creating a One-to-Many List - Page 221
Mail Merge: Creating a One-to-Many List - Page 222
Mail Merge: Creating a One-to-Many List - Page 223
Mail Merge: Creating a One-to-Many List - Page 224
Mail Merge: Creating a One-to-Many List - Page 225
Mail Merge: Creating a One-to-Many List - Page 226
Mail Merge: Creating a One-to-Many List - Page 227
Mail Merge: Creating a One-to-Many List - Page 228
Mail Merge: Creating a One-to-Many List - Page 229
Mail Merge: Creating a One-to-Many List - Page 230
Mail Merge: Merging with a Chart - Page 231
Mail Merge: Merging with a Chart - Page 232
Mail Merge: Merging with a Chart - Page 233
Mail Merge: Merging with a Chart - Page 234
Mail Merge: Merging with a Chart - Page 235
Mail Merge: Merging with a Chart - Page 236
Mail Merge: Merging with a Chart - Page 237
Mail Merge: Merging with a Chart - Page 238
Mail Merge: Merging with a Chart - Page 239
Mail Merge: Merging with a Chart - Page 240
Transferring a Selection to a New Document - Page 241
Transferring a Selection to a New Document - Page 242
Transferring a Selection to a New Document - Page 243
Transferring a Selection to a New Document - Page 244
Transferring a Selection to a New Document - Page 245
Splitting a Document into Multiple Files - Page 246
Splitting a Document into Multiple Files - Page 247
Splitting a Document into Multiple Files - Page 248
Splitting a Document into Multiple Files - Page 249
Splitting a Document into Multiple Files - Page 250
Splitting a Document into Multiple Files - Page 251
Creating a Folder Tree Menu - Page 252
Creating a Folder Tree Menu - Page 253
Creating a Folder Tree Menu - Page 254
Creating a Folder Tree Menu - Page 255
Creating a Folder Tree Menu - Page 256
Creating a Folder Tree Menu - Page 257
Creating a Folder Tree Menu - Page 258
Creating a Folder Tree Menu - Page 259
Creating a Folder Tree Menu - Page 260
Changing Custom Dictionaries On-the-Fly - Page 261
Changing Custom Dictionaries On-the-Fly - Page 262
Changing Custom Dictionaries On-the-Fly - Page 263
Changing Custom Dictionaries On-the-Fly - Page 264
Formatting Spelling Errors for Printing - Page 265
Formatting Spelling Errors for Printing - Page 266
Formatting Spelling Errors for Printing - Page 267
Formatting Spelling Errors for Printing - Page 268
Formatting Spelling Errors for Printing - Page 269
Entering Data Easily Using a Custom Dialog Box - Page 270
Entering Data Easily Using a Custom Dialog Box - Page 271
Entering Data Easily Using a Custom Dialog Box - Page 272
Entering Data Easily Using a Custom Dialog Box - Page 273
Entering Data Easily Using a Custom Dialog Box - Page 274
Entering Data Easily Using a Custom Dialog Box - Page 275
Creating a Bookmark from a Selection - Page 276
Creating a Bookmark from a Selection - Page 277
Creating a Bookmark from a Selection - Page 278
Creating a Bookmark from a Selection - Page 279
Making Bookmarks Visible - Page 280
Forcing the User to Enable Macros - Page 281
Forcing the User to Enable Macros - Page 282
Using Forms Protection - Page 283
Using Forms Protection - Page 284
Outlook Procedures - Page 285
Outlook Procedures - Page 286
Saving E-mail Attachments in a Specified Folder - Page 287
Saving E-mail Attachments in a Specified Folder - Page 288
Saving E-mail Attachments in a Specified Folder - Page 289
Creating a Contacts Database - Page 290
Creating a Contacts Database - Page 291
Creating a Contacts Database - Page 292
Creating a Contacts Database - Page 293
Creating a Contacts Database - Page 294
Sending a Web Page as the Body of an E-mail Message - Page 295
Sending a Web Page as the Body of an E-mail Message - Page 296
Sending a Web Page as the Body of an E-mail Message - Page 297
Sending a Message Individually to Multiple Recipients - Page 298
Sending a Message Individually to Multiple Recipients - Page 299
Sending a Message Individually to Multiple Recipients - Page 300
Sending a Message Individually to Multiple Recipients - Page 301
Sending a Message Individually to Multiple Recipients - Page 302
Sending Daily Attachments to Certain Recipients - Page 303
Sending Daily Attachments to Certain Recipients - Page 304
Sending Daily Attachments to Certain Recipients - Page 305
Creating Reminders Automatically - Page 306
Creating Reminders Automatically - Page 307
Creating Reminders Automatically - Page 308
Creating Reminders Automatically - Page 309
Creating Task Items Automatically in Outlook - Page 310
Creating Task Items Automatically in Outlook - Page 311
Creating Task Items Automatically in Outlook - Page 312
Creating Task Items Automatically in Outlook - Page 313
Creating Task Items Automatically in Outlook - Page 314
Creating Task Items Automatically in Outlook - Page 315
Special: Outlook Security - Page 316
Auto Replying to Selected E-mail Messages - Page 317
Remote Control with Outlook E-mail Message - Page 318
Remote Control with Outlook E-mail Message - Page 319
Remote Control with Outlook E-mail Message - Page 320
PowerPoint Procedures - Page 321
Manipulating AutoShapes - Page 322
Manipulating AutoShapes - Page 323
Grabbing All Text - Page 324
Grabbing All Text - Page 325
Moving Shapes and Graphics During Presentation - Page 326
Moving Shapes and Graphics During Presentation - Page 327
Moving Shapes and Graphics During Presentation - Page 328
Making a Random Jump to Another Slide - Page 329
Making a Random Jump to Another Slide - Page 330
Random Madness - Page 331
Sending Word Outline to Notes Section of PowerPoint - Page 332
Sending Word Outline to Notes Section of PowerPoint - Page 333
Sending Word Outline to Notes Section of PowerPoint - Page 334
Wrapping Text to the Next Slide - Page 335
Wrapping Text to the Next Slide - Page 336
Saving the Show Point - Page 337
Personalizing a Presentation - Page 338
Personalizing a Presentation - Page 339
Creating a New Presentation - Page 340
Creating a New Presentation - Page 341
Creating a New Presentation - Page 342
Access Procedures - Page 343
Access Procedures - Page 344
Access Procedures - Page 345
Access Procedures - Page 346
Designing Consistent Forms - Page 347
Designing Consistent Forms - Page 348
Designing Consistent Forms - Page 349
Triggering a New Form Based on a Subform Selection - Page 350
Triggering a New Form Based on a Subform Selection - Page 351
Triggering a New Form Based on a Subform Selection - Page 352
Selecting and Filtering with Cascading Combo Boxes - Page 353
Selecting and Filtering with Cascading Combo Boxes - Page 354
Selecting and Filtering with Cascading Combo Boxes - Page 355
Selecting and Filtering with Cascading Combo Boxes - Page 356
Selecting and Filtering with Cascading Combo Boxes - Page 357
E-mailing a Selection - Page 358
E-mailing a Selection - Page 359
E-mailing a Selection - Page 360
E-mailing a Selection - Page 361
Making a Rolodex-type Selection List Box - Page 362
Making a Rolodex-type Selection List Box - Page 363
Making a Rolodex-type Selection List Box - Page 364
Making a Rolodex-type Selection List Box - Page 365
Validating Data - Page 366
Validating Data - Page 367
Validating Data - Page 368
Moving Rows Between List Boxes - Page 369
Moving Rows Between List Boxes - Page 370
Moving Rows in List Boxes - Page 371
Moving Rows in List Boxes - Page 372
Creating a Dynamic Crosstab Report - Page 373
Creating a Dynamic Crosstab Report - Page 374
Generating Periodic Reports - Page 375
Generating Periodic Reports - Page 376
Creating Controlled Numbers - Page 377
Creating Controlled Numbers - Page 378
Making a Wizard with Tabbed Control - Page 379
Making a Wizard with Tabbed Control - Page 380
Making a Wizard with Tabbed Control - Page 381
Making a Wizard with Tabbed Control - Page 382
Combined Procedures - Page 383
Saving Word Form Data to an Excel Spreadsheet - Page 384
Saving Word Form Data to an Excel Spreadsheet - Page 385
Saving Word Form Data to an Excel Spreadsheet - Page 386
Filling a Word Combo Box with Data from Excel - Page 387
Filling a Word Combo Box with Data from Excel - Page 388
Filling a Word Combo Box with Data from Excel - Page 389
Filling a Word Combo Box with Data from Excel - Page 390
Filling a Word Combo Box with Data from Excel - Page 391
Filling a Word Combo Box with Data from Excel - Page 392
Filling a Word Combo Box with Data from Excel - Page 393
Transferring Data from E-mail Attachments to Excel - Page 394
Transferring Data from E-mail Attachments to Excel - Page 395
Transferring Data from E-mail Attachments to Excel - Page 396
Transferring Data from E-mail Attachments to Excel - Page 397
Creating Word Labels from an Excel Recipient List - Page 398
Creating Word Labels from an Excel Recipient List - Page 399
Creating Word Labels from an Excel Recipient List - Page 400
Creating Word Labels from an Excel Recipient List - Page 401
Creating Word Labels from an Excel Recipient List - Page 402
Creating Word Labels from an Excel Recipient List - Page 403
Creating Word Labels from an Excel Recipient List - Page 404
Creating Custom Mail Merge Using Data in Excel Worksheet - Page 405
Creating Custom Mail Merge Using Data in Excel Worksheet - Page 406
Using Calendar Control for Office Applications - Page 407
Using Calendar Control for Office Applications - Page 408
Using Calendar Control for Office Applications - Page 409
Using Calendar Control for Office Applications - Page 410
Using Calendar Control for Office Applications - Page 411
Using Calendar Control for Office Applications - Page 412
Using Calendar Control for Office Applications - Page 413
Using Calendar Control for Office Applications - Page 414
Using Calendar Control for Office Applications - Page 415
Using Calendar Control for Office Applications - Page 416
Using Calendar Control for Office Applications - Page 417
Using Calendar Control for Office Applications - Page 418
Appendix A - Page 419
Locating the Code Object - Page 420
Locating the Code Object - Page 421
Inserting a Module - Page 422
Inserting a UserForm - Page 423
Inserting a UserForm - Page 424
Inserting a UserForm - Page 425
Opening Worksheet Objects (Excel) - Page 426
Opening Worksheet Objects (Excel) - Page 427
Opening ThisWorkbook Object (Excel) - Page 428
Opening ThisOutlookSession Objects (Outlook) - Page 429
Opening Slide Objects (Powerpoint) - Page 430
Access Objects - Page 431
- Page 432
Appendix B - Page 433
Running a Macro from a Toolbar Button - Page 434
Running a Macro Using Shortcut Keys - Page 435