Master Visually Excel 2003 Vba Programming

Covers everything experienced Excel users need to know about customizing, automating and supercharging Excel applications!

List of contents

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.

Product details

• Authors: Julia Kelly
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 22.02.2005
• EAN: 9780764579738
• ISBN: 978-0-7645-7973-8
• No. of pages: 432
• Series: Master VISUALLY; Master Visually
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > Application software