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 LEADER 07116nam 2200697 a 450 001 9910965908803321 005 20251017110059.0 010 $a9786610191741 010 $a9780309174862 010 $a0309174864 010 $a9781280191749 010 $a1280191740 010 $a9780309562287 010 $a0309562287 035 $a(CKB)110986584751952 035 $a(SSID)ssj0000192735 035 $a(PQKBManifestationID)11937192 035 $a(PQKBTitleCode)TC0000192735 035 $a(PQKBWorkID)10198157 035 $a(PQKB)11655950 035 $a(Au-PeEL)EBL3377091 035 $a(CaPaEBR)ebr10068323 035 $a(OCoLC)923268199 035 $a(MiAaPQ)EBC3377091 035 $a(Perlego)4733721 035 $a(DNLM)827028 035 $a(BIP)47377447 035 $a(EXLCZ)99110986584751952 100 $a19970506d1997 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aLinking research and public health practice $ea review of CDC's program of centers for research and demonstration of health promotion and disease prevention /$fMichael A. Stoto, Lawrence W. Green, and Linda A. Bailey, editors 205 $a1st ed. 210 $aWashington, D.C. $cNational Academy Press$d1997 215 $ax, 107 p 300 $a"Committee to Review the CDC Centers for Research and Demonstration of Health Promotion and Disease Prevention, Board on Health Promotion and Disease Prevention, Institute of Medicine." 311 08$a9780309056809 311 08$a0309056802 320 $aIncludes bibliographical references (p. 65-67). 327 $aLinking Research and Public Health Practice -- Copyright -- Preface -- Contents -- Executive Summary -- CHARGE TO THE COMMITTEE -- A VISION FOR THE PREVENTION CENTERS RESEARCH PROGRAM -- THE RESEARCH AND DEMONSTRATION PROJECTS CONDUCTED BY THE PREVENTION RESEARCH CENTERS -- Innovation -- Setting Priorities in the PRCs -- Dissemination and Implementation Activities -- MANAGEMENT AND OVERSIGHT OF THE PREVENTION RESEARCH CENTERS PROGRAM -- Vision and Goals -- Thematic Focus -- CDC's Role in Networking, Communication, and Dissemination -- Criteria for Evaluating Prevention Research Centers -- Funding for the PRC Program -- SUMMARY AND CONCLUSIONS -- 1 Introduction -- HISTORY OF THE PREVENTION RESEARCH CENTERS PROGRAM -- GROWTH OF THE PRC PROGRAM -- CDC'S REQUEST FOR A REVIEW OF THE PRC PROGRAM -- Organization of the Study -- Methodology for Reviewing the PRC Program -- OVERALL IMPRESSIONS -- ADDITIONAL PERSPECTIVES ON THE PRC PROGRAM -- 2 A Vision for the Prevention Research Centers Program -- THE CHALLENGE AHEAD -- Purpose of the PRC Program -- A Vision for the Future -- A Focus on Risk Conditions and Social Determinants of Health -- An Orientation Toward the Community -- Interdisciplinarity -- A Means for Dissemination Research in Public Health -- An Interactive Process for Establishing Research Priorities -- A Role in Setting National Research Priorities -- 3 The Research and Demonstration Projects Conducted by the Prevention Research Centers -- INNOVATIONS -- SETTING PRIORITIES IN THE PRCS -- Criteria for Project Selection -- Quality Control -- Peer Review -- Public Health Impact -- Balance in Research Portfolios -- DISSEMINATION AND IMPLEMENTATION ACTIVITIES -- Prevention Networks -- Dissemination Research -- SUMMARY AND CONCLUSIONS -- 4 Management and Oversight of the Prevention Research Centers Program -- VISION AND GOALS. 327 $aPrevention Research -- THEMATIC FOCUS -- NETWORKING, COMMUNICATION, AND DISSEMINATION -- Improved Communication and Interaction -- Community Input -- Dissemination Research -- CRITERIA FOR EVALUATING PRCS -- Progress Reports -- Peer Review -- FUNDING FOR THE PRC PROGRAM -- Core Funding -- Open Competition -- Special Interest Projects -- Allocation of Core Funds -- SUMMARY AND CONCLUSIONS -- References -- Appendix A Committee Biographies -- Appendix B Charge to the Committee -- Appendix C Protocol for Site Visits and Telephone Interviews, June 1996 -- PROTOCOL FOR SITE VISIT TO CDC -- Appendix D The CDC Prevention Research Centers Program: A Decade of Achievement, 1986-1996, and an Agenda for the Decade ? -- THE CDC PREVENTION RESEARCH CENTERS PROGRAM: A DECADE OF ACHIEVEMENT, 1986-1996 AND AN AGENDA FOR THE DECADE AHEAD -- The Critical Need for "Prevention Research" -- Achievements of the Program: 1986-1996 -- The Agenda for a Second Decade of Success -- THE CDC PREVENTION RESEARCH CENTERS PROGRAM: A DECADE OF ACHIEVEMENT, 1986-1996 AND AN AGENDA FOR THE DECADE AHEAD -- Summary -- Introduction -- The Background of Program Authorization and implementation -- The Critical Need for "Prevention Research" -- Achievements of the Program: 1986-1996 -- The Agenda for a Second Decade of Success -- Program Objectives, 1996-2006 -- Acknowledgments -- THE CDC PREVENTION RESEARCH CENTERS PROGRAM: A DECADE OF ACHIEVEMENT, 1986-1996 AND AN AGENDA FOR THE DECADE AHEAD -- PROGRAM OBJECTIVES: 1996-2006 -- Appendix E Prevention Research Centers: Investing in the Nation's Health, 1986-1996 -- National Research Network -- High-Priority Research Themes -- Support for National Health Objectives -- Value-Added Funding of Prevention Research -- Benefits of Continuity -- Extending the Public Health Mission -- Key Accomplishments. 330 $aHealth promotion and disease prevention are central priorities in the Centers for Disease Control and Prevention (CDC) vision. To advance research in these areas, Congress authorized and CDC established a program of university-based Centers for Research and Demonstration of Health Promotion and Disease Prevention to explore improved ways of appraising health hazards and to serve as demonstration sites for new and innovative research in public health. Begun in 1986 with three centers, there are now fourteen. In response to a CDC request to evaluate the program, Linking Research and Public Health Practice examines the vision for the prevention research centers program, the projects conducted by the centers, and the management and oversight of the program. In conducting the evaluation, the IOM committee took a broad view of how prevention research can influence the health of communities, and considered both the proximal risk factors for disease prevention and the more distal conditions for health promotion and improved equity in the distribution of risk factors. Month? 517 3 $aReview of CDC's program of centers for research and demonstration of health promotion and disease prevention 606 $aMedicine, Preventive$zUnited States 606 $aHealth promotion$zUnited States 615 0$aMedicine, Preventive 615 0$aHealth promotion 676 $a614.4/0973 701 $aStoto$b Michael A$01123282 701 $aGreen$b Lawrence W$0907406 701 $aBailey$b Linda A$01807204 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910965908803321 996 $aLinking research and public health practice$94358505 997 $aUNINA