Excel® 2007 Power Programming with VBA

Copyright © 2007 Wiley Publishing, Inc., Indianapolis, Indiana

Excel® 2007 Power Programming with VBA

Author(s): John Walkenbach

Published Online: 30 NOV 2011 11:11AM EST

Print ISBN: 9780470044018

Online ISBN: 9781118257593

DOI: 10.1002/9781118257593

About this Book

Product Information

About The Product
  • This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
  • Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere else
  • John Walkenbach, aka "Mr. Spreadsheet," is one of the world's leading authorities on Excel
  • Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
  • Includes a valuable CD-ROM with templates and worksheets from the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of contents

    1. You have free access to this content
      Front Matter (pages i–xxxviii)

  2. Part I: Some Essential Background

    1. Chapter 1

      Excel 2007: Where It Came From (pages 1–14)

    2. Chapter 2

      Excel in a Nutshell (pages 15–45)

    3. Chapter 3

      Formula Tricks and Techniques (pages 47–71)

    4. Chapter 4

      Understanding Excel's Files (pages 73–94)

  3. Part II: Excel Application Development

    1. Chapter 5

      What Is a Spreadsheet Application? (pages 95–107)

    2. Chapter 6

      Essentials of Spreadsheet Application Development (pages 109–129)

  4. Part III: Understanding Visual Basic for Applications

    1. Chapter 7

      Introducing Visual Basic for Applications (pages 131–188)

    2. Chapter 8

      VBA Programming Fundamentals (pages 189–236)

    3. Chapter 9

      Working with VBA Sub Procedures (pages 237–274)

    4. Chapter 10

      Creating Function Procedures (pages 275–314)

    5. Chapter 11

      VBA Programming Examples and Techniques (pages 315–386)

  5. Part IV: Working with UserForms

    1. Chapter 12

      Custom Dialog Box Alternatives (pages 387–411)

    2. Chapter 13

      Introducing UserForms (pages 413–448)

    3. Chapter 14

      UserForm Examples (pages 449–485)

    4. Chapter 15

      Advanced UserForm Techniques (pages 487–530)

  6. Part V: Advanced Programming Techniques

    1. Chapter 16

      Developing Excel Utilities with VBA (pages 531–554)

    2. Chapter 17

      Working with Pivot Tables (pages 555–570)

    3. Chapter 18

      Working with Charts (pages 571–627)

    4. Chapter 19

      Understanding Excel's Events (pages 629–668)

    5. Chapter 20

      Interacting with Other Applications (pages 669–697)

    6. Chapter 21

      Creating and Using Add-Ins (pages 699–724)

  7. Part VI: Developing Applications

    1. Chapter 22

      Working with the Ribbon (pages 725–759)

    2. Chapter 23

      Working with Shortcut Menus (pages 761–779)

    3. Chapter 24

      Providing Help for Your Applications (pages 781–799)

    4. Chapter 25

      Developing User-Oriented Applications (pages 801–814)

  8. Part VII: Other Topics

    1. Chapter 26

      Compatibility Issues (pages 815–828)

    2. Chapter 27

      Manipulating Files with VBA (pages 829–858)

    3. Chapter 28

      Manipulating Visual Basic Components (pages 859–883)

    4. Chapter 29

      Understanding Class Modules (pages 885–900)

    5. Chapter 30

      Working with Colors (pages 901–928)

    6. Chapter 31

      Frequently Asked Questions about Excel Programming (pages 929–967)

  9. Part VIII: Appendixes

    1. You have free access to this content
      Appendix A: Excel Resources Online (pages 969–976)

    1. You have free access to this content
      Appendix B: VBA Statements and Functions Reference (pages 977–987)

    1. You have free access to this content
      Appendix C: VBA Error Codes (pages 989–992)

    1. You have free access to this content
      Appendix D: What's on the CD-ROM (pages 993–1009)

    1. You have free access to this content
      Index (pages 1011–1061)

    1. You have free access to this content
      Advertisement (pages 1063–1066)

SEARCH