Absolute Beginner's Guide to VBA 

1 2 3

• 1. Absolute Beginner s Guide to VBA

• 2. Table of Contents

• 3. Copyright

  Copyright Copyright 2004 by Que Publishing Trademarks Warning and Disclaimer Bulk Sales Credits Dedication

• 4. About the Author

  About the Author

• 5. Acknowledgments

  Acknowledgments

• 6. We Want to Hear from You

  We Want to Hear from You

• 7. Introduction

  Introduction

• 8. What You Should Know Before Reading This Book

  What You Should Know Before Reading This Book

• 9. This Book s Special Features

  This Book s Special Features

• 10. Part I: Getting Started with VBA

• 11. Chapter 1. Recording Your First Macro

  Chapter 1. Recording Your First Macro

• 12. What Is a Macro?

  What Is a Macro?

• 13. Recording a VBA Macro

  The Absolute Minimum Recording a VBA Macro

• 14. Chapter 2. Writing Your Own Macros

  Chapter 2. Writing Your Own Macros

• 15. Displaying the Visual Basic Editor

  Displaying the Visual Basic Editor

• 16. Touring the Visual Basic Editor

  Touring the Visual Basic Editor

• 17. Writing Your Own Command Macro

  Writing Your Own Command Macro

• 18. Running a VBA Macro

  Running a VBA Macro

• 19. Creating User-Defined Functions with VBA

  Creating User-Defined Functions with VBA

• 20. Working with Procedures

  Working with Procedures

• 21. Working with Modules

  Working with Modules

• 22. Shutting Down the Visual Basic Editor

  The Absolute Minimum Shutting Down the Visual Basic Editor

• 23. Chapter 3. Understanding Program Variables

  Chapter 3. Understanding Program Variables

• 24. Declaring Variables

  Declaring Variables

• 25. Avoiding Variable Errors

  Avoiding Variable Errors

• 26. Variable Data Types

  Variable Data Types

• 27. Using Array Variables

  Using Array Variables

• 28. Working with Constants

  The Absolute Minimum Working with Constants

• 29. Chapter 4. Building VBA Expressions

  Chapter 4. Building VBA Expressions

• 30. Working with VBA Operators

  Working with VBA Operators

• 31. Understanding Operator Precedence

  Understanding Operator Precedence

• 32. Working with Numeric Expressions

  Working with Numeric Expressions

• 33. Working with String Expressions

  Working with String Expressions

• 34. Working with Logical Expressions

  Working with Logical Expressions

• 35. Working with Date Expressions

  The Absolute Minimum Working with Date Expressions

• 36. Chapter 5. Working with Objects

  Chapter 5. Working with Objects

• 37. The Object Hierarchy

  The Object Hierarchy

• 38. Working with Object Properties

  Working with Object Properties

• 39. Working with Object Methods

  Working with Object Methods

• 40. Handling Object Events

  Handling Object Events

• 41. Working with Object Collections

  Working with Object Collections

• 42. Assigning an Object to a Variable

  Assigning an Object to a Variable

• 43. The Is Operator

  The Is Operator

• 44. Working with Multiple Properties or Methods

  Working with Multiple Properties or Methods

• 45. Example: The Application Object

  Example: The Application Object

• 46. Example: The Window Object

  The Absolute Minimum Example: The Window Object

• 47. Chapter 6. Controlling Your VBA Code

  Chapter 6. Controlling Your VBA Code

• 48. Code That Makes Decisions

  Code That Makes Decisions

• 49. Using If...Then to Make TrueFalse Decisions

  Using If...Then to Make TrueFalse Decisions

• 50. Using If...Then...Else to Handle a False Result

  Using If...Then...Else to Handle a False Result

1 2 3