Excel VBA Programming For Dummies
ISBN: 9780470503690 | 0470503696
Edition: 2ndFormat: Paperback
Publisher: For Dummies
Pub. Date: 5/24/2010
Why Rent from Knetbooks?
Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!
Top 5 reasons to order all your textbooks from Knetbooks:
- We have the lowest prices on thousands of popular textbooks
- Free shipping both ways on ALL orders
- Most orders ship within 48 hours
- Need your book longer than expected? Extending your rental is simple
- Our customer support team is always here to help
Accelerate into the Excel fast lane and zip through spreadsheet customizationsAre you ready to make Excel jump through hoops? Do your spreadsheets work exactly the way you want? With this book, you can say "yes"! Inside, you'll find step-by-step instructions on how to significantly enhance the power of Excel using the VBA language. You'll soon be building your own Excel applications so you can get the most out of your data.Dive into VBA - see how VBA is implemented in Excel, apply advanced techniques, and use VBA with other Office applicationsG... MORE
| Introduction | |
| Introducing VBA | |
| What Is VBA? | |
| Jumping Right In | |
| How VBA Works with Excel | |
| Working In the Visual Basic Editor | |
| Introducing the Excel Object Model | |
| VBA Sub and Function Procedures | |
| Using the Excel Macro Recorder | |
| Programming Concepts | |
| Essential VBA Language Elements | ... MORE |
| Working with Range Objects | |
| Using VBA and Worksheet Functions | |
| Controlling Program Flow and Making Decisions | |
| Automatic Procedures and Events | |
| Error-Handling Techniques | |
| Bug Extermination Techniques | |
| VBA Programming Examples | |
| Communicating with Your Users | |
| Simple Dialog Boxes | |
| UserForm Basics | |
| Using UserForm Controls | |
| UserForm Techniques and Tricks | |
| Accessing Your Macros through the User Interface | |
| Putting It All Together | |
| Creating Worksheet Functions - and Living to Tell about It | |
| Creating Excel Add-Ins | |
| The Part of Tens | |
| Ten VBA Questions | |
| (Almost) Ten Excel Resources | |
| Index | |
| Table of Contents provided by Publisher. All Rights Reserved. |
John Walkenbach is principal of J Walk and Associates, Inc, a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. Walkenbach has written more than 50 books and 300 articles for publications including PC World InfoWorld, and Windows.
Please wait while this item is added to your cart...
