Excel 2007 VBA Programming For Dummies
Published on 15. February 2007
Book
Paperback/Softback
388 pages
978-0-470-04674-6 (ISBN)
Description
Step-by-step instructions for creating VBA macros
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
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
More details
Product info
WebSite Associated w/Book
Edition
1. Auflage
Language
English
Place of publication
United States
Publishing group
John Wiley & Sons Inc
Target group
Professional and scholarly
Dimensions
Height: 23.3 cm
Width: 18.5 cm
Thickness: 1.7 cm
Weight
544 gr
ISBN-13
978-0-470-04674-6 (9780470046746)
Schweitzer Classification
Other editions
New editions
John Walkenbach
Excel VBA Programming For Dummies
Book
05/2010
2nd Edition
Wiley
€28.90
Article exhausted; check for reprint
Additional editions
John Walkenbach
Excel 2007 VBA Programming For Dummies
E-Book
02/2011
Wiley
€20.99
Available for download
John Walkenbach
Excel 2007 VBA Programming For Dummies
E-Book
09/2007
Wiley
€20.99
Available for download
Persons
John Walkenbach is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak.
Content
Introduction.
Part I: Introducing VBA.
Chapter 1: What Is VBA?
Chapter 2: Jumping Right In.
Part II: How VBA Works with Excel.
Chapter 3: Working In the Visual Basic Editor.
Chapter 4: Introducing the Excel Object Model.
Chapter 5: VBA Sub and Function Procedures.
Chapter 6: Using the Excel Macro Recorder.
Part III: Programming Concepts.
Chapter 7: Essential VBA Language Elements.
Chapter 8: Working with Range Objects.
Chapter 9: Using VBA and Worksheet Functions.
Chapter 10: Controlling Program Flow and Making Decisions.
Chapter 11: Automatic Procedures and Events.
Chapter 12: Error-Handling Techniques.
Chapter 13: Bug Extermination Techniques.
Chapter 14: VBA Programming Examples.
Part IV: Communicating with Your Users.
Chapter 15: Simple Dialog Boxes.
Chapter 16: UserForm Basics.
Chapter 17: Using UserForm Controls.
Chapter 18: UserForm Techniques and Tricks.
Chapter 19: Accessing Your Macros Through the User Interface.
Part V: Putting It All Together.
Chapter 20: Creating Worksheet Functions and Living to Tell about It.
Chapter 21: Creating Excel Add-Ins.
Part VI: The Part of Tens.
Chapter 22: Ten VBA Questions (And Answers)
Chapter 23: (Almost) Ten Excel Resources.
Index.
Part I: Introducing VBA.
Chapter 1: What Is VBA?
Chapter 2: Jumping Right In.
Part II: How VBA Works with Excel.
Chapter 3: Working In the Visual Basic Editor.
Chapter 4: Introducing the Excel Object Model.
Chapter 5: VBA Sub and Function Procedures.
Chapter 6: Using the Excel Macro Recorder.
Part III: Programming Concepts.
Chapter 7: Essential VBA Language Elements.
Chapter 8: Working with Range Objects.
Chapter 9: Using VBA and Worksheet Functions.
Chapter 10: Controlling Program Flow and Making Decisions.
Chapter 11: Automatic Procedures and Events.
Chapter 12: Error-Handling Techniques.
Chapter 13: Bug Extermination Techniques.
Chapter 14: VBA Programming Examples.
Part IV: Communicating with Your Users.
Chapter 15: Simple Dialog Boxes.
Chapter 16: UserForm Basics.
Chapter 17: Using UserForm Controls.
Chapter 18: UserForm Techniques and Tricks.
Chapter 19: Accessing Your Macros Through the User Interface.
Part V: Putting It All Together.
Chapter 20: Creating Worksheet Functions and Living to Tell about It.
Chapter 21: Creating Excel Add-Ins.
Part VI: The Part of Tens.
Chapter 22: Ten VBA Questions (And Answers)
Chapter 23: (Almost) Ten Excel Resources.
Index.