文档介绍：spine=.8160”
Computers/Spreadsheets
™
2nd Edition
Accelerate into the Excel Making Everything Easier!
fast lane and zip through 2nd Edition
Excel
Microsoft ®
spreadsheet customizations Open the book and find: Microsoft ®
Are you ready to make Excel jump through hoops? Do ®
• How to work in the Visual Basic ®
your spreadsheets work exactly the way you want? With Editor
®
this book, you can say “yes”! Inside, you’ll find step-by-step VBA Programming
• Tips for error-handling and bug VBA
instructions on how to significantly enhance the power of extermination Excel
Excel using the VBA language. You’ll soon be building your
• Ways to build automatic
own Excel applications so you can get the most out of procedures and events
your data.
• How to use the Excel macro
• Dive into VBA — see how VBA is implemented in Excel, apply recorder
advanced techniques, and use VBA with other Office applications Programming
• UserForm techniques and tricks
• Get into it — explore programming concepts from range objects
and worksheet functions to events and error-handling • Instructions for designing VBA
macros
• Communication is key — learn how to build dialog boxes that
look like they came straight from Microsoft’s software lab • Steps for accessing your macros
through the user interface
• Safety first — use Excel macros to make your spreadsheets more
secure and lock out viruses • Secrets for creating Excel add-ins
• Make it your own — develop custom worksheet functions, create
add-ins, design user-oriented applications, and boost your
career options
Learn to:
• Use the essential tools and operations
Go to ® for VBA
Visit panion Web site at / for videos, step-by-step examples,
go/excelvbaprogrammingfd2e, where you can download the how-to articles, or to shop! • Work with range objects and control
sample files featured in the book and view bonus chapters program flow
• Handle errors and el