The Resource Excel 2007 VBA programming for dummies, by John Walkenbach ; revised by Jan Karel Pieterse, (electronic resource)

Excel 2007 VBA programming for dummies, by John Walkenbach ; revised by Jan Karel Pieterse, (electronic resource)

Label
Excel 2007 VBA programming for dummies
Title
Excel 2007 VBA programming for dummies
Statement of responsibility
by John Walkenbach ; revised by Jan Karel Pieterse
Creator
Contributor
Subject
Genre
Language
  • eng
  • eng
Summary
Step-by-step instructions for creating VBA macrosHarness the power of VBA and create custom Excel applicationsMake Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.Discover how to* Grasp essential programming concepts* Use the Visual Basic(r) Editor* Navigate the new Excel user interf
Member of
Cataloging source
MiAaPQ
http://library.link/vocab/creatorName
Walkenbach, John
Dewey number
005.54
Illustrations
illustrations
Index
index present
Language note
English
LC call number
HF5548.4.M523
LC item number
W3397 2007
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
Pieterse, Jan Karel
Series statement
--For dummies
http://library.link/vocab/subjectName
  • Business
  • Electronic spreadsheets
Label
Excel 2007 VBA programming for dummies, by John Walkenbach ; revised by Jan Karel Pieterse, (electronic resource)
Instantiates
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • Excel 2007 VBA Programming For Dummies; 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; Marginal Icons; Get 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; An Excursion into Versions
  • Chapter 2: Jumping Right InFirst 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 Explorer; Working with a Code Window; Customizing the VBA Environment; Chapter 4: Introducing the Excel Object Model; Excel Is an Object?; Climbing the Object Hierarchy
  • Wrapping Your Mind around CollectionsReferring 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; Using Variables, Constants, and Data Types
  • Using Assignment StatementsWorking 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; Looping through a Collection
  • Chapter 11: Automatic Procedures and EventsPreparing 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; Chapter 14: VBA Programming Examples
  • Working with Ranges
Dimensions
unknown
Extent
1 online resource (402 p.)
Form of item
online
Isbn
9780470142363
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000356875
  • (EBL)285167
  • (OCoLC)85854817
  • (SSID)ssj0000151690
  • (PQKBManifestationID)12007401
  • (PQKBTitleCode)TC0000151690
  • (PQKBWorkID)10320611
  • (PQKB)11539597
  • (MiAaPQ)EBC285167
  • (EXLCZ)991000000000356875
Label
Excel 2007 VBA programming for dummies, by John Walkenbach ; revised by Jan Karel Pieterse, (electronic resource)
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • Excel 2007 VBA Programming For Dummies; 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; Marginal Icons; Get 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; An Excursion into Versions
  • Chapter 2: Jumping Right InFirst 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 Explorer; Working with a Code Window; Customizing the VBA Environment; Chapter 4: Introducing the Excel Object Model; Excel Is an Object?; Climbing the Object Hierarchy
  • Wrapping Your Mind around CollectionsReferring 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; Using Variables, Constants, and Data Types
  • Using Assignment StatementsWorking 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; Looping through a Collection
  • Chapter 11: Automatic Procedures and EventsPreparing 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; Chapter 14: VBA Programming Examples
  • Working with Ranges
Dimensions
unknown
Extent
1 online resource (402 p.)
Form of item
online
Isbn
9780470142363
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000356875
  • (EBL)285167
  • (OCoLC)85854817
  • (SSID)ssj0000151690
  • (PQKBManifestationID)12007401
  • (PQKBTitleCode)TC0000151690
  • (PQKBWorkID)10320611
  • (PQKB)11539597
  • (MiAaPQ)EBC285167
  • (EXLCZ)991000000000356875

Library Locations

  • Albert D. Cohen Management LibraryBorrow it
    181 Freedman Crescent, Winnipeg, MB, R3T 5V4, CA
    49.807878 -97.129961
  • Architecture/Fine Arts LibraryBorrow it
    84 Curry Place, Winnipeg, MB, CA
    49.807716 -97.136226
  • Archives and Special CollectionsBorrow it
    25 Chancellors Circle (Elizabeth Dafoe Library), Room 330, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Bibliothèque Alfred-Monnin (Université de Saint-Boniface)Borrow it
    200, avenue de la Cathédrale, Local 2110, Winnipeg, MB, R2H 0H7, CA
    49.888861 -97.119735
  • Bill Larson Library (Grace Hospital)Borrow it
    300 Booth Drive, G-227, Winnipeg, MB, R3J 3M7, CA
    49.882400 -97.276436
  • Carolyn Sifton - Helene Fuld Library (St. Boniface General Hospital)Borrow it
    409 Tache Avenue, Winnipeg, MB, R2H 2A6, CA
    49.883388 -97.126050
  • Concordia Hospital LibraryBorrow it
    1095 Concordia Avenue, Winnipeg, MB, R2K 3S8, CA
    49.913252 -97.064683
  • Donald W. Craik Engineering LibraryBorrow it
    75B Chancellors Circle (Engineering Building E3), Room 361, Winnipeg, MB, R3T 2N2, CA
    49.809053 -97.133292
  • E.K. Williams Law LibraryBorrow it
    224 Dysart Road, Winnipeg, MB, R3T 5V4, CA
    49.811829 -97.131017
  • Eckhardt-Gramatté Music LibraryBorrow it
    136 Dafoe Road (Taché Arts Complex), Room 257, Winnipeg, MB, R3T 2N2, CA
    49.807964 -97.132222
  • Elizabeth Dafoe LibraryBorrow it
    25 Chancellors Circle, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Fr. H. Drake Library (St. Paul's College)Borrow it
    70 Dysart Road, Winnipeg, MB, R3T 2M6, CA
    49.810605 -97.138184
  • J.W. Crane Memorial Library (Deer Lodge Centre)Borrow it
    2109 Portage Avenue, Winnipeg, MB, R3J 0L3, CA
    49.878000 -97.235520
  • Libraries Annex (not open to the public; please see web page for details)Borrow it
    25 Chancellors Circle (in the Elizabeth Dafoe Library), Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Neil John Maclean Health Sciences LibraryBorrow it
    727 McDermot Avenue (Brodie Centre), 200 Level, Winnipeg, MB, R3E 3P5, CA
    49.903563 -97.160554
  • Sciences and Technology LibraryBorrow it
    186 Dysart Road, Winnipeg, MB, R3T 2M8, CA
    49.811526 -97.133257
  • Seven Oaks General Hospital LibraryBorrow it
    2300 McPhillips Street, Winnipeg, MB, R2V 3M3, CA
    49.955177 -97.148865
  • Sister St. Odilon Library (Misericordia Health Centre)Borrow it
    99 Cornish Avenue, Winnipeg, MB, R3C 1A2, CA
    49.879592 -97.160425
  • St. John's College LibraryBorrow it
    92 Dysart Road, Winnipeg, MB, R3T 2M5, CA
    49.811242 -97.137156
  • Victoria General Hospital LibraryBorrow it
    2340 Pembina Highway, Winnipeg, MB, R3T 2E8, CA
    49.806755 -97.152739
  • William R Newman Library (Agriculture)Borrow it
    66 Dafoe Road, Winnipeg, MB, R3T 2R3, CA
    49.806936 -97.135525
Processing Feedback ...