| Introduction |
ix |
| Part 1 Automating Everyday Tasks
| . |
| Chapter 1 Make a Macro Do Simple Tasks |
5 |
| How Visual Basic for Applications Talks to Excel |
5 |
| Creating a Simple Macro |
7 |
| Changing Multiple Properties at Once |
12 |
| Editing a Recorded Macro |
16 |
| Recording Actions in a Macro |
18 |
| Chapter 2 Make a Macro Do Complex Tasks |
27 |
| Divide and Conquer |
28 |
| Task One: Opening the Report File |
29 |
| Task Two: Filling in Missing Labels |
35 |
| Task Three: Adding a Column of Dates |
39 |
| Task Four: Appending to the Database |
41 |
| Task Five: Deleting the Worksheet |
48 |
| Assembling the Pieces |
49 |
| Part 1 Review and Practice |
53 |
| Shifting a Column |
53 |
| Adding a Row with Formulas |
55 |
| Part 2 Exploring Objects |
. |
| Chapter 3 Explore Microsoft Excel's Object Library |
61 |
| Using the Locals Window to Learn About Objects |
62 |
| Using the Immediate Window to Learn About Objects |
69 |
| Using Help to Learn About Objects |
74 |
| Using Auto Lists to Learn About Objects |
79 |
| Using the Object Browser to Learn About Objects |
85 |
| Chapter 4 Explore Range Objects |
91 |
| Enhancing Recorded Selections |
91 |
| Exploring Ranges |
94 |
| Exploring Formulas |
102 |
| Chapter 5 Explore Graphical Objects |
113 |
| Exploring Graphical Objects |
113 |
| Exploring Chart Objects |
121 |
| Chapter 6 Explore PivotTable Objects |
133 |
| Building PivotTables |
133 |
| Refining PivotTables |
138 |
| Part 2 Review and Practice |
149 |
| Add Totals to a Table |
149 |
| Synchronize Two PivotTables |
151 |
| Chart a Row from a PivotTable |
152 |
| Part 3 Exploring Visual Basic |
. |
| Chapter 7 Controlling Visual Basic |
159 |
| Using Conditionals |
160 |
| Creating Loops |
167 |
| Managing Large Loops |
173 |
| Chapter 8 Extending Excel and Visual Basic |
181 |
| Creating Custom Functions |
181 |
| Handling Errors |
188 |
| Part 3 Review and Practice |
201 |
| Display the Full File Name |
201 |
| Create Selective Totals from a List |
202 |
| Part 4 Making Macros Easy to Use |
. |
| Chapter 9 Launching Macros with Events |
209 |
| Creating Custom Toolbars and Menus |
210 |
| Creating Custom Command Buttons |
217 |
| Handling Worksheet and Workbook Events |
227 |
| Chapter 10 Using Dialog Box Controls on a Worksheet |
235 |
| Using a Loan Payment Calculator |
236 |
| Creating an Error-Resistant Loan Payment Calculator |
238 |
| Retrieving a Value from a List |
242 |
| Protecting the Worksheet |
246 |
| Chapter 11 Creating a Custom Form |
251 |
| Creating a Form's User Interface |
251 |
| Preparing a Form's Functionality |
263 |
| Implementing a Form |
270 |
| Chapter 12 Creating an Enterprise Information System |
279 |
| Examining an Existing Enterprise Information System |
280 |
| Charting Data from a Database |
283 |
| Controlling the Report with Macros |
294 |
| Creating a Graphical Interface |
298 |
| Packaging the Application |
305 |
| Part 4 Review and Practice |
317 |
| Create a Form |
318 |
| Part 5 Appendixes |
. |
| Appendix A Alternative Techniques |
327 |
| Chapter 1 |
327 |
| Chapter 2 |
328 |
| Chapter 3 |
329 |
| Chapter 4 |
330 |
| Chapter 5 |
330 |
| Chapter 7 |
330 |
| Chapter 8 |
331 |
| Chapter 9 |
331 |
| Chapter 11 |
332 |
| Chapter 12 |
333 |
| Appendix B Checking Your Configuration |
335 |
| Excel Environment |
335 |
| Visual Basic Editor Environment |
337 |
| Index |
339 |
