Excel VBA Programming For Dummies View Larger Image | John Walkenbach
Wiley, Paperback, Published August 2004, 390 pages, ISBN 0764574124 | List Price: $24.99
Our Price: $14.95
You Save: $10.04 (40% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
* Shows ordinary users how to harness the power of Visual Basic for Applications
(VBA) and create custom Excel applications
* This book introduces people to a wide array of new Excel options, including
creating new worksheet functions, automating tasks and operations, creating
new toolbars and menus, designing custom dialog boxes and add-ins, and much
more
* Begins with the most important tools and operations for the Visual Basic Editor,
then provides an overview of the essential elements and concepts for programming
with Excel
* John Walkenbach, a.k.a. "Mr. Spreadsheet," runs a popular Web site
(www.j-walk.com) on Excel techniques and is the author of many bestselling books
on Excel
Table of Contents
Introduction.
Part I: Introducing VBA.
Chapter 1: What Is VBA?
Chapter 2: Jumping Right In.
Part II: How VBA Works with Excel.
Chapter 3: Introducing 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: Developing Custom Dialog Boxes.
Chapter 15: Custom Dialog Box Alternatives.
Chapter 16: Custom Dialog Box Basics.
Chapter 17: Using Dialog Box Controls.
Chapter 18: UserForm Techniques and Tricks.
Part V: Creating Custom Toolbars and Menus.
Chapter 19: Customizing the Excel Toolbars.
Chapter 20: When the Normal Excel Menus Aren’t Good Enough.
Part VI: Putting It All Together.
Chapter 21: Creating Worksheet Functions — and Living to Tell about
It.
Chapter 22: Creating Excel Add-Ins.
Chapter 23: Interacting with Other Office Applications.
Part VII: The Part of Tens.
Chapter 24: Ten VBA Questions (And Answers).
Chapter 25: (Almost) Ten Excel Resources.
Index.
About the Author
John Walkenbach is principal of J-Walk and Associates, Inc., a leading Excel
expert, and proprietor of the popular spreadsheet page at www.j-walk.com. He
has written more than 30 books on Excel.
|
