Absolute Beginner's Guide to VBA |
By Paul McFedries |
|
Publisher | : Que |
Pub Date | : March 09, 2004 |
ISBN | : 0-7897-3076-6 |
Pages | : 384 |
| |
| 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 True/False 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 |