LEADER 05372nam 2200673Ia 450 001 9910783278403321 005 20200520144314.0 010 $a1-280-26598-1 010 $a9786610265985 010 $a0-7645-7898-7 035 $a(CKB)1000000000023357 035 $a(EBL)214343 035 $a(OCoLC)271808266 035 $a(SSID)ssj0000151675 035 $a(PQKBManifestationID)11144712 035 $a(PQKBTitleCode)TC0000151675 035 $a(PQKBWorkID)10319488 035 $a(PQKB)11431865 035 $a(Au-PeEL)EBL214343 035 $a(CaPaEBR)ebr10114237 035 $a(CaONFJC)MIL26598 035 $a(CaSebORM)9780764556609 035 $a(MiAaPQ)EBC214343 035 $a(EXLCZ)991000000000023357 100 $a20040401d2004 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 00$aExcel 2003 VBA programmer's reference$b[electronic resource] /$fPaul Kimmel ... [et al.] 205 $a1st edition 210 $aIndianapolis, IN. $cWiley Pub.$dc2004 215 $a1 online resource (1176 p.) 225 1 $aProgrammer to programmer 300 $aIncludes index. 311 $a0-7645-5660-6 327 $aAbout the Authors; Acknowledgments; Introduction; Chapter 1: Primer in Excel VBA; Using the Macro Recorder; Recording Macros; Running Macros; The Visual Basic Editor; Other Ways to Run Macros; User Defined Functions; Creating a UDF; What UDFs Cannot Do; The Excel Object Model; Objects; Getting Help; Experimenting in the Immediate Window; The VBA Language; Basic Input and Output; Calling Functions and Subroutines; Variable Declaration; Scope and Lifetime of Variables; Variable Type; Object Variables; Making Decisions; Looping; Arrays; Runtime Error Handling; Summary 327 $aChapter 2: Programming in the VBEWriting Code; Programming for People; Writing Code; Where Does My Code Go?; Managing a Project; Adding Classes; Modifying Properties; Importing and Exporting Visual Basic Code; Editing; Managing Editor Options; Running and Debugging Code; Using Watches; Using the Object Browser; Summary; Chapter 3: The Application Object; Globals; The Active Properties; Display Alerts; Screen Updating; Evaluate; InputBox; StatusBar; SendKeys; OnTime; OnKey; Worksheet Functions; Caller; Summary; Chapter 4: Object-Oriented Theory and VBA; Comparing Classes and Interfaces 327 $aDefining an InterfaceImplementing an Interface; Defining Methods; Parameters; Implementing Recursive Methods; Eliminating Recursion with Loops; Defining Fields; Defining Properties; Defining Events; Defining Events in Classes; Raising Events; Handling Events; Information Hiding and Access Modifiers; Encapsulation, Aggregation, and References; Summary; Chapter 5: Event Procedures; Worksheet Events; Enable Events; Worksheet Calculate; Chart Events; Before Double Click; Workbook Events; Save Changes; Headers and Footers; Summary; Chapter 6: Class Modules; Creating Your Own Objects 327 $aUsing CollectionsClass Module Collection; Trapping Application Events; Embedded Chart Events; A Collection of UserForm Controls; Referencing Classes Across Projects; Summary; Chapter 7: Writing Bulletproof Code; Using Debug.Print; Using Debug.Assert; A Brief Exemplar of PC Debugging; Creating Reusable Tools with the Debug Object; Tracing Code Execution; Trapping Code Execution Paths; Asserting Application Invariants; Raising Errors; Writing Error Handlers; On Error Goto Line Number; On Error Resume Next; On Error GoTo 0; Using the Err Object; Scaffolding; Writing to the EventLog; Summary 327 $aChapter 8: Debugging and TestingStepping Through Code; Running Your Code; Stepping into Your Code; Step Over; Step Out; Run to Cursor; Set Next Statement; Show Next Statement; Using Breakpoints; Using Watches; Add Watch; Edit Watch; Quick Watch; Locals Windows; Testing an Expression in the Immediate Window; Resources for Finding Definitions; Edit => Quick Info; Edit => Parameter Info; Edit => Complete Word; Edit => List Properties/Methods; Edit => List Constants; Edit => Bookmarks; View => Definition; View => Object Browser; Viewing the Call Stack; Asserting Application Invariants; Summary 327 $aChapter 9: UserForms 330 $aWhat is this book about? Excel 2003 VBA Programmer's Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal. The book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications for other users. The book starts with a primer chapter focused on bringing the readers up to speed with Excel and VBA. From there, the book expands to focus on major issues faced by advanced Excel users and developers. What does this book c 606 $aBusiness$xComputer programs 606 $aElectronic spreadsheets 606 $aComputer software$xDevelopment 615 0$aBusiness$xComputer programs. 615 0$aElectronic spreadsheets. 615 0$aComputer software$xDevelopment. 676 $a005.54 701 $aKimmel$b Paul$01496874 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910783278403321 996 $aExcel 2003 VBA programmer's reference$93721794 997 $aUNINA