Fr. 24.10

Master Visually Excel 2003 Vba Programming

English · Paperback / Softback

New edition in preparation, currently unavailable

Description

Read more

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

Customer reviews

No reviews have been written for this item yet. Write the first review and be helpful to other users when they decide on a purchase.

Write a review

Thumbs up or thumbs down? Write your own review.

For messages to CeDe.ch please use the contact form.

The input fields marked * are obligatory

By submitting this form you agree to our data privacy statement.