Home » , , » Download PDF Excel 2002 Power Programming with VBA by John Walkenbach

Download PDF Excel 2002 Power Programming with VBA by John Walkenbach


To fully appreciate the application development features available in Excel 2002, it’s important to understand
where this product came from and how it fits into the overall scheme of things. If you’ve worked with personal computers and spreadsheets over the past decade, this information may be old hat. If you’re a trivia buff, this chapter is a gold mine. Study this chapter and you’ll be a hit at the next computer geek party you attend.

Most of us tend to take spreadsheet software for granted. In fact, it may be hard to fathom, but there really was a time when electronic spreadsheets were not available. Back then, people relied instead on clumsy mainframes or calculators and spent hours doing what now takes minutes.

The world’s first electronic spreadsheet, VisiCalc, was conjured up by Dan Bricklin and Bob Frankston back in 1978, when personal computers were pretty much unheard of in the office environment. VisiCalc was written for the Apple II computer, an interesting little machine that is something of a toy by today’s standards. But in its day, the Apple II kept me mesmerized for days at a time. VisiCalc essentially laid the foundation for future spreadsheets, and its row-and-column-based layout and formula syntax are still found in modern spreadsheet products. VisiCalc caught on quickly, and many forward-looking companies purchased the Apple II for the sole purpose of developing their budgets with VisiCalc. Consequently, VisiCalc is often credited for much of the Apple II’s initial success.


  1. Some Essential Background
  2. Excel 2002: Where It Came From
  3. Excel in a Nutshell
  4. Formula Tricks and Techniques
  5. Understanding Excel’s Files
  6. Excel Application Development
  7. What is a Spreadsheet Application?
  8. Essentials of Spreadsheet Application Development
  9. Understanding Visual Basic for Applications
  10. Introducing Visual Basic for Applications
  11. VBA Programming Fundamentals
  12. Working with VBA Sub Procedures
  13. Creating Function Procedures
  14. VBA Programming Examples and Techniques
  15. Working with UserForms
  16. Custom Dialog Box Alternatives
  17. Introducing UserForms
  18. UserForm Examples
  19. Advanced UserForm Techniques
  20. Advanced Programming Techniques
  21. Developing Excel Utilities with VBA
  22. Working with Pivot Tables
  23. Working with Charts
  24. Understanding Excel’s Events
  25. Interacting with Other Applications
  26. Creating and Using Add-Ins
  27. Developing Applications
  28. Creating Custom Toolbars
  29. Creating Custom Menus
  30. Providing Help for Your Applications
  31. Developing User-Oriented Applications
  32. Other Topics
  33. Compatibility Issues
  34. Manipulating Files with VBA
  35. Manipulating Visual Basic Components
  36. Understanding Class Modules
  37. Frequently Asked Questions about Excel Programming

0 komentar:

Posting Komentar