Absolute Beginners Guide to VBA
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 146
Pages: 146
Authors: Paul McFedries
- 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
- Getting Ready: Two Steps Before You Begin
- Working with Database Records: Opening a Recordset
- Working with a Recordset
- Retrieving Data into Excel
- Chapter 11. Programming Outlook Email
- Working with Outlook Folders
- Working with Email Messages
- Sending a Message
- Working with Attachments
- Programming Outlook from Other Applications
- Part III: Getting the Most Out of VBA
- Chapter 12. Interacting with the User
- Programming Sounds
- Displaying Information to the User
- Getting Input from the User
- Chapter 13. Creating Custom VBA Dialog Boxes
- Adding a Form to Your Project
- Changing the Form s Design-Time Properties
- Working with Controls
- Handling Form Events
- Types of Form Controls
- Using a Form in a Procedure
- Chapter 14. Creating Custom Menus and Toolbars
- Assigning Macros to Menu Commands
- Creating Custom Toolbars for Your Macros
- Menus, Toolbars, and VBA
- Understanding Command Bars
- Working with Command Bar Controls
- Chapter 15. Debugging VBA Procedures
- Trapping Program Errors
- A Basic Strategy for Debugging
- Pausing a Procedure
- Stepping Through a Procedure
- Monitoring Procedure Values
- Using the Immediate Window
- Debugging Tips
- Part IV: Appendixes
- Appendix A. VBA Statements
- Appendix B. VBA Functions
- Index
- index_SYMBOL
- index_A
- index_B
- index_C
- index_D
- index_E
- index_F
- index_G
- index_H
- index_I
- index_J
- index_K
- index_L
- index_M
- index_N
- index_O
- index_P
- index_Q
- index_R
- index_S
- index_T
- index_U
- index_V
- index_W
- index_X
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 146
Pages: 146
Authors: Paul McFedries