Master Visually Excel 2003 VBA Programming

Julia Kelly is a writer, teacher, and consultant for desktop applications, including Excel, Access, Word, Publisher, and Outlook. She's taught classroom courses in Excel at major corporations and Outlook courses on-line for several years, and has authored 17 book on Office applications. In addition, she develops Excel and Access applications for business clients.

PART I: CREATING SIMPLE MACROS. 1. Recording Simple Macros. 2. Running Macros. 3. Recording Complex Macros. 4. Simplifying and Protecting Macros. PART II: EXPLORING THE VISUAL BASIC EDITOR. 5. Getting to Know the Visual Basic Editor. 6. Using the Visual Basic Editor. 7. Manipulating Modules and Projects. PART III: MANIPULATING WORKBOOKS AND WORKSHEETS. 8. Writing Workbook Macros. 9. Creating Worksheet Macros. 10. Changing Worksheet Settings. PART IV: WORKING WITH RANGES. 11. Selecting and Manipulating Ranges. 12. Formatting Ranges. 13. Entering Data and Formulas. PART V: MAKING A MACRO SMART. 14. Setting Conditions. 15. Using Loops. 16. Fixing Errors. PART VI: CREATING CHART AND PIVOTTABLE MACROS. 17. Writing Chart Macros. 18. Modifying Chart Macros. 19. Writing PivotTable Macros. PART VII: USING FORMS AND CONTROLS. 20. Creating Worksheet Controls. 21. Creating Programmed Controls. 22. Controlling Macros and Events. 23. Polishing with Extra Macros.