Absolute Beginners Guide to VBA - page 1
- 1
- 2
- Absolute Beginner s Guide to VBA
- Absolute Beginner s Guide to VBA
- Table of Contents
- Copyright
- About the Author
- Acknowledgments
- We Want to Hear from You
- Introduction
- What You Should Know Before Reading This Book
- This Book s Special Features
- Part I: Getting Started with VBA
- Chapter 1. Recording Your First Macro
- What Is a Macro?
- Recording a VBA Macro
- Chapter 2. Writing Your Own Macros
- Displaying the Visual Basic Editor
- Touring the Visual Basic Editor
- Writing Your Own Command Macro
- Running a VBA Macro
- Creating User-Defined Functions with VBA
- Working with Procedures
- Working with Modules
- Shutting Down the Visual Basic Editor
- Chapter 3. Understanding Program Variables
- Declaring Variables
- Avoiding Variable Errors
- Variable Data Types
- Using Array Variables
- Working with Constants
- Chapter 4. Building VBA Expressions
- Working with VBA Operators
- Understanding Operator Precedence
- Working with Numeric Expressions
- Working with String Expressions
- Working with Logical Expressions
- Working with Date Expressions
- Chapter 5. Working with Objects
- The Object Hierarchy
- Working with Object Properties
- Working with Object Methods
- Handling Object Events
- Working with Object Collections
- Assigning an Object to a Variable
- The Is Operator
- Working with Multiple Properties or Methods
- Example: The Application Object
- Example: The Window Object
- Chapter 6. Controlling Your VBA Code
- Code That Makes Decisions
- Using If...Then to Make TrueFalse Decisions
- Using If...Then...Else to Handle a False Result
- Making Multiple Decisions
- Functions That Make Decisions
- Code That Loops
- Using Do...Loop Structures
- Using For...Next Loops
- Using For Each...Next Loops
- Using Exit For or Exit Do to Exit a Loop
- Part II: Putting VBA to Work
- Chapter 7. Programming Word
- Working with Documents
- Working with Text
- The Range Object
- The Selection Object
- The Characters Object
- The Words Object
- The Sentences Object
- The Paragraph Object
- Chapter 8. Programming Excel
- Excel s Application Object
- Manipulating Workbook Objects
- Dealing with Worksheet Objects
- Working with Range Objects
- Chapter 9. Programming PowerPoint
- PowerPoint s Application Object
- PowerPoint s Presentation Object
- Working with PowerPoint Slide Objects
- Dealing with Shape Objects
- Operating a Slide Show
- Chapter 10. Programming Access Databases
- 1
- 2
