05353nam 2200697 450 991083006040332120230725023455.01-282-68510-497866126851011-118-25765-00-470-63275-5(CKB)2670000000018903(EBL)530024(OCoLC)630541049(SSID)ssj0000417353(PQKBManifestationID)11259444(PQKBTitleCode)TC0000417353(PQKBWorkID)10361521(PQKB)10771837(MiAaPQ)EBC530024(MiAaPQ)EBC4957883(Au-PeEL)EBL4957883(CaONFJC)MIL268510(OCoLC)650251753(EXLCZ)99267000000001890320160809h20102010 uy 0engur|n|---|||||txtccrExcel VBA programming for dummies /by John Walkenbach2nd ed.Hoboken, New Jersey :Wiley Publishing, Inc.,2010.©20101 online resource (432 p.)For DummiesIncludes index.0-470-50369-6 Excel® 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 NutshellAn 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?Climbing 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 CodeUsing 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 LoopLooping 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 TipsChapter 14: VBA Programming ExamplesTake 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--For dummies.Electronic spreadsheetsBusinessComputer programsElectronic spreadsheets.BusinessComputer programs.005.368/2005.54Walkenbach John61459MiAaPQMiAaPQMiAaPQBOOK9910830060403321Excel VBA programming for dummies3984955UNINA