Microsoft Office Excel 2007 VBA Programming for Dummies

Name: Microsoft Office Excel 2007 VBA Programming for Dummies
Author: John Walkenbach

Paperback Engels 2007 1e druk 9780470046746

Dit product is niet leverbaar

Samenvatting

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.

Discover how to
- Grasp essential programming concepts
- Use the Visual Basic(r) Editor
- Navigate the new Excel user interface
- Communicate with your users
- Deal with errors and bugs

Specificaties

ISBN13:9780470046746

Taal:Engels

Bindwijze:paperback

Aantal pagina's:368

Uitgever:John Wiley & Sons

Druk:1

Verschijningsdatum:14-2-2007

Hoofdrubriek:IT-management / ICT

Serie:Dummies (Engelstalig)

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Uw cijfer

?

Log in om te stemmen

Inhoudsopgave

Introduction.

Part 1: Introducing VBA.
1. What Is VBA?
2. Jumping Right In.

Part 2: How VBA Works with Excel.
3. Working In the Visual Basic Editor.
4. Introducing the Excel Object Model.
5. VBA Sub and Function Procedures.
6. Using the Excel Macro Recorder.

Part 3: Programming Concepts.
7. Essential VBA Language Elements.
8. Working with Range Objects.
9. Using VBA and Worksheet Functions.
10. Controlling Program Flow and Making Decisions.
11. Automatic Procedures and Events.
12. Error-Handling Techniques.
13. Bug Extermination Techniques.
14. VBA Programming Examples.

Part 4: Communicating with Your Users.
15. Simple Dialog Boxes.
16. UserForm Basics.
17. Using UserForm Controls.
18. UserForm Techniques and Tricks.
19. Accessing Your Macros Through the User Interface.

Part 5: Putting It All Together.
20. Creating Worksheet Functions and Living to Tell about It.
21. Creating Excel Add-Ins.

Part 6: The Part of Tens.
22. Ten VBA Questions (And Answers)
23. (Almost) Ten Excel Resources.

Index.