Excel VBA Programming for Dummies

Name: Excel VBA Programming for Dummies
Price: 4.07 USD
Availability: InStock
ISBN: 9780470503690

ISBN-10: 0470503696

ISBN-13: 9780470503690

Edition: 2nd 2010

Authors: John Walkenbach

List price: $37.95

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $4.07

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Take your Excel skills to the next level with VBA programmingNow that you've mastered Excel basics, it's time to move to the next levelcreating your own, customized Excel 2010 solutions using Visual Basic for Applications (VBA). The new edition of this non-threatening guide is your key to getting there. Using step-by-step instruction and the accessible, friendly For Dummies style, this practical book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.The book's Web site provides all the programming examples from the book. Introduces you to a new range of Excel 2010 options Shows you how to use Visual Basic for…

Book details

List price: $37.95
Edition: 2nd
Copyright year: 2010
Publisher: John Wiley & Sons, Incorporated
Publication date: 5/7/2010
Binding: Paperback
Pages: 408
Size: 7.40" wide x 9.30" long x 0.91" tall
Weight: 1.342
Language: English



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



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