LEADER 05387nam 2200709 450 001 9910140569703321 005 20210209231534.0 010 $a1-282-68510-4 010 $a9786612685101 010 $a1-118-25765-0 010 $a0-470-63275-5 035 $a(CKB)2670000000018903 035 $a(EBL)530024 035 $a(OCoLC)630541049 035 $a(SSID)ssj0000417353 035 $a(PQKBManifestationID)11259444 035 $a(PQKBTitleCode)TC0000417353 035 $a(PQKBWorkID)10361521 035 $a(PQKB)10771837 035 $a(MiAaPQ)EBC530024 035 $a(MiAaPQ)EBC4957883 035 $a(Au-PeEL)EBL4957883 035 $a(CaONFJC)MIL268510 035 $a(OCoLC)650251753 035 $a(EXLCZ)992670000000018903 100 $a20160809h20102010 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel VBA programming for dummies /$fby John Walkenbach 205 $a2nd ed. 210 1$aHoboken, New Jersey :$cWiley Publishing, Inc.,$d2010. 210 4$d©2010 215 $a1 online resource (432 p.) 225 1 $aFor Dummies 300 $aIncludes index. 311 $a0-470-50369-6 327 $aExcel® VBA Programming For Dummies®, 2nd Edition; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; Is This the Right Book?; So You Want to Be a Programmer . . .; Why Bother?; What I Assume about You; Obligatory Typographical Conventions Section; Check Your Security Settings; How This Book Is Organized; Icons Used in This Book; Getting the Sample Files; Now What?; Part I: Introducing VBA; Chapter 1: What Is VBA?; Okay, So What Is VBA?; What Can You Do with VBA?; Advantages and Disadvantages of VBA; VBA in a Nutshell 327 $aAn Excursion into VersionsChapter 2: Jumping Right In; First Things First; What You'll Be Doing; Taking the First Steps; Recording the Macro; Testing the Macro; Examining the Macro; Modifying the Macro; Saving Workbooks That Contain Macros; Understanding Macro Security; More about the NameAndTime Macro; Part II: How VBA Works with Excel; Chapter 3: Working In the Visual Basic Editor; What Is the Visual Basic Editor?; Working with the Project Window; Working with a Code Window; Customizing the VBA Environment; Chapter 4: Introducing the Excel Object Model; Excel Is an Object? 327 $aClimbing the Object HierarchyWrapping Your Mind around Collections; Referring to Objects; Diving into Object Properties and Methods; Finding Out More; Chapter 5: VBA Sub and Function Procedures; Subs versus Functions; Executing Sub procedures; Executing Function procedures; Chapter 6: Using the Excel Macro Recorder; Is It Live or Is It VBA?; Recording Basics; Preparing to Record; Relative or Absolute?; What Gets Recorded?; Recording Options; Is This Thing Efficient?; Part III: Programming Concepts; Chapter 7: Essential VBA Language Elements; Using Comments in Your VBA Code 327 $aUsing Variables, Constants, and Data TypesUsing Assignment Statements; Working with Arrays; Using Labels; Chapter 8: Working with Range Objects; A Quick Review; Other Ways to Refer to a Range; Some Useful Range Object Properties; Some Useful Range Object Methods; Chapter 9: Using VBA and Worksheet Functions; What Is a Function?; Using Built-In VBA Functions; Using Worksheet Functions in VBA; More about Using Worksheet Functions; Using Custom Functions; Chapter 10: Controlling Program Flow and Making Decisions; Going with the Flow, Dude; The GoTo Statement; Knocking Your Code for a Loop 327 $aLooping through a CollectionChapter 11: Automatic Procedures and Events; Preparing for the Big Event; Where Does the VBA Code Go?; Writing an Event-Handler Procedure; Introductory Examples; Examples of Activation Events; Other Worksheet-Related Events; Events Not Associated with Objects; Chapter 12: Error-Handling Techniques; Types of Errors; An Erroneous Example; Handling Errors Another Way; Handling Errors: The Details; An Intentional Error; Chapter 13: Bug Extermination Techniques; Species of Bugs; Identifying Bugs; Debugging Techniques; About the Debugger; Bug Reduction Tips 327 $aChapter 14: VBA Programming Examples 330 $aTake your Excel skills to the next level with VBA programming Now that you've mastered Excel basics, it's time to move to the next level-creating 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 410 0$a--For dummies. 606 $aElectronic spreadsheets 606 $aBusiness$xComputer programs 608 $aElectronic books. 615 0$aElectronic spreadsheets. 615 0$aBusiness$xComputer programs. 676 $a005.368/2 676 $a005.54 700 $aWalkenbach$b John$061459 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910140569703321 996 $aExcel VBA programming for dummies$91957371 997 $aUNINA