Download PDF Excel 2002 Power Programming with VBA by John Walkenbach

Sinopsis

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.

Content

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

Click here to download