| |
| |
| Introduction | |
| |
| |
| What the Book Covers | |
| |
| |
| I Shouldn't Make Any Assumptions ... | |
| |
| |
| Divide and Conquer | |
| |
| |
| How to Use the Examples | |
| |
| |
| What's on the CD-ROM | |
| |
| |
| Icons Used in This Book | |
| |
| |
| The VBA For Dummies Web Site(s) | |
| |
| |
| |
| VBA Boot Camp | |
| |
| |
| |
| Don't Sweat the Technical Stuff--and It's All Technical Stuff | |
| |
| |
| Why Bother with VBA? | |
| |
| |
| VBA Is the Steering Wheel, but You Still Need the Car | |
| |
| |
| Programming with VBA | |
| |
| |
| More about What You Can Do with VBA | |
| |
| |
| Not Your Mama's BASIC | |
| |
| |
| |
| Don't Program When You Can Record a Macro | |
| |
| |
| Understanding How Macros Work | |
| |
| |
| Planning a Macro | |
| |
| |
| Recording Macros | |
| |
| |
| Modifying Macros--the Easy Way to Write Code | |
| |
| |
| |
| Basic VBA Programming | |
| |
| |
| Starting the Visual Basic Editor | |
| |
| |
| I Need Help! | |
| |
| |
| Creating a VBA Program | |
| |
| |
| Running a Form from Other VBA Code | |
| |
| |
| Returning to Your VBA Application | |
| |
| |
| |
| Running VBA Programs | |
| |
| |
| The Name Is Everything | |
| |
| |
| Running from the Macros dialog box | |
| |
| |
| Launching Programs Quickly | |
| |
| |
| Running VBA Programs Automatically | |
| |
| |
| |
| The Visual Basic Editor at Your Command | |
| |
| |
| Working with the Visual Basic Editor User Interface | |
| |
| |
| Managing the Windows | |
| |
| |
| Managing Your Projects with Project Explorer | |
| |
| |
| Using the Object Browser | |
| |
| |
| Coding Secrets | |
| |
| |
| Using the Properties Window | |
| |
| |
| A First Look at the Debugging Windows | |
| |
| |
| |
| VBA Programming Essentials | |
| |
| |
| |
| Anatomy of a Great VBA Program | |
| |
| |
| Program Building Blocks | |
| |
| |
| Where Do Projects Come from, Mommy? | |
| |
| |
| Totally Modular | |
| |
| |
| Writing Procedures | |
| |
| |
| Scoping Out the Scope | |
| |
| |
| Making Statements | |
| |
| |
| Naming Your Babies | |
| |
| |
| Making Your Code Pretty | |
| |
| |
| Remarks About Comments | |
| |
| |
| |
| Storing and Modifying Information | |
| |
| |
| Working with Variables | |
| |
| |
| Working with Values Constant-ly | |
| |
| |
| Hello, Operators | |
| |
| |
| Details on Data Types | |
| |
| |
| |
| Controlling the Flow | |
| |
| |
| Controlling Wild Programs with Control Structures | |
| |
| |
| The Road Taken: Using Condition Expressions | |
| |
| |
| Using if...Then Statements | |
| |
| |
| Using Select Case Statements | |
| |
| |
| Repeating Yourself with Loops | |
| |
| |
| Interrupting the Flow with GoTo | |
| |
| |
| |
| Unbreakable Code: Debugging and Error Trapping | |
| |
| |
| What Can Go Wrong Does Go Wrong | |
| |
| |
| Fixing Syntax Errors | |
| |
| |
| Entomology for VBA Programmers | |
| |
| |
| Seeing Data Tips | |
| |
| |
| Immediate Gratification | |
| |
| |
| Keeping an Eye on the Locals (Window) | |
| |
| |
| The Watch Window: Key Debugging Tool | |
| |
| |
| Trapping Wild Bugs with On Error and the Error Object | |
| |
| |
| |
| Creating Interactive VBA Forms | |
| |
| |
| Designing Forms | |
| |
| |
| Controls, Behave Yourself! | |
| |
| |
| Form Programming | |
| |
| |
| |
| Stretching Out | |
| |
| |
| |
| Built-in VBA Commands | |
| |
| |
| Finding Built-In Commands | |
| |
| |
| Formatting Data | |
| |
| |
| Converting Data | |
| |
| |
| Con Text | |
| |
| |
| Working with Dates and Times | |
| |
| |
| Simple Interactions with the World | |
| |
| |
| Fun with Math and Money | |
| |
| |
| Miscellaneous Built-In Commands | |
| |
| |
| |
| Object-Oriented Programming | |
| |
| |
| So What's an Object? | |
| |
| |
| What's an Object Model? | |
| |
| |
| VBA Forms Are Objects, Too | |
| |
| |
| Using Objects in Code: An Introduction | |
| |
| |
| Getting and Changing Object Properties | |
| |
| |
| Method Acting | |
| |
| |
| Comprehending Events | |
| |
| |
| Identifying the Object You Want to Work With | |
| |
| |
| Efficient Object Coding | |
| |
| |
| |
| Baskets for Data Storage: Arrays and Collections | |
| |
| |
| Seeing A-rray of Hope | |
| |
| |
| Managing Sets of Data with Collection Objects | |
| |
| |
| Defining Your Own Data Types | |
| |
| |
| |
| The Part of Tens | |
| |
| |
| |
| Ten (Minus Three) Really Cool Things You Can Do with VBA | |
| |
| |
| |
| Ten (Times Three) VBA Resources | |
| |
| |
| |
| About the CD | |
| |
| |
| Bonus Part: Extras (On the CD-ROM) | |
| |
| |
| |
| VBA Programming in Office | |
| |
| |
| Taking Control of Toolbars and Menus | |
| |
| |
| Programming the Office Assistant | |
| |
| |
| Storing Document Variables | |
| |
| |
| |
| VBA Programming in Word | |
| |
| |
| Understanding the Application Object | |
| |
| |
| Accessing World Documents in VBA | |
| |
| |
| Opening Windows with VBA | |
| |
| |
| Working with the Selection Object | |
| |
| |
| Understanding Range Objects | |
| |
| |
| Working with Text in Word VBA | |
| |
| |
| Finding and Replacing in Word VBA | |
| |
| |
| Using Document Variables | |
| |
| |
| |
| VBA Programming in Excel | |
| |
| |
| Navigating the Excel Object Model | |
| |
| |
| Working with Cells in Code Using Range Objects | |
| |
| |
| Programming Custom Worksheet Functions | |
| |
| |
| Using Built-In Functions in Your Code | |
| |
| |
| Programming for Excel Events | |
| |
| |
| |
| Database Programming | |
| |
| |
| Backgrounder on VBA Database Programming Technology | |
| |
| |
| Database programming choices | |
| |
| |
| Writing Database Code with ADO | |
| |
| |
| Working with SQL | |
| |
| |
| |
| Working with Disk Files | |
| |
| |
| The Number Is the Key | |
| |
| |
| |
| More on VBA Forms | |
| |
| |
| More on Form and Control Appearance | |
| |
| |
| More on Working with Controls | |
| |
| |
| More on Form Programming | |
| |
| |
| Index | |
| |
| |
| Hungry Minds End-User License Agreement | |
| |
| |
| Installation Instructions | |