Excel VBA 24-Hour Trainer, 2nd Edition

Master VBA automation quickly and easily to get more out ofExcel

Excel VBA 24-Hour Trainer, 2nd Edition is thequick-start guide to getting more out of Excel, using Visual Basicfor Applications. This unique book/video package has been updatedwith fifteen new advanced video lessons, providing a total ofeleven hours of video training and 45 total lessons to teach youthe basics and beyond. This self-paced tutorial explains Excel VBAfrom the ground up, demonstrating with each advancing lesson howyou can increase your productivity. Clear, concise, step-by-stepinstructions are combined with illustrations, code examples, anddownloadable workbooks to give you a practical, in-depth learningexperience and results that apply to real-world scenarios.

This is your comprehensive guide to becoming a true Excel poweruser, with multimedia instruction and plenty of hands-onpractice. * Program Excel’s newest chart and pivot table object models * Manipulate the user interface to customize the look and feel ofa project * Utilize message boxes, input boxes, and loops to yieldcustomized logical results * Interact with and manipulate Word, Access, PowerPoint, andOutlook from Excel

If you’re ready to get more out of this incredibly functionalprogram, Excel VBA 24-Hour Trainer, 2nd Edition provides theexpert instruction and fast, hands-on learning you need.

Table of Contents

Part I: Understanding the BASICs
Lesson 1: Introducing VBA
Lesson 2: Getting Started with Macros
Lesson 3: Introducing the Visual Basic Editor
Lesson 4: Working in the VBE

Part II: Diving Deeper into VBA
Lesson 5: Object-Oriented Programming: An Overview
Lesson 6: Variables, Data Types, and Constants
Lesson 7: Understanding Objects and Collections
Lesson 8: Working with Ranges
Lesson 9: Making Decisions with VBA

Part III: Beyond the Macro Recorder: Writing Your Own Code
Lesson 10: Repeating Actions with Loops
Lesson 11: Programming Formulas
Lesson 12: Working with Arrays
Lesson 13: Automating Procedures with Worksheet Events
Lesson 14: Automating Procedures with Workbook Events
Lesson 15: Handling Duplicate Items and Records
Lesson 16: Using Embedded Controls
Lesson 17: Programming Charts
Lesson 18: Programming PivotTables and PivotCharts
Lesson 19: User-Defined Functions
Lesson 20: Debugging Your Code

Part IV: Advanced Programming Techniques
Lesson 21: Creating UserForms
Lesson 22: UserForm Controls and Their Functions
Lesson 23: Advanced UserForms
Lesson 24: Class Modules
Lesson 25: Add-Ins
Lesson 26: Managing External Data
Lesson 27: Data Access with ActiveX Data Objects
Lesson 28: Impressing Your Boss (or at Least Your Friends)

Part V: Interacting with Other Office Applications
Lesson 29: Overview of Office Automation from Excel
Lesson 30: Working with Word from Excel
Lesson 31: Working with Outlook from Excel
Lesson 32: Working with Access from Excel
Lesson 33: Working with PowerPoint from Excel