Excel 2003 Power Programming with VBA
- 14h
- John Walkenbach
- John Wiley & Sons (US)
- 2004
Everything you need to know about:
- Creating stellar UserForms and custom dialog box alternatives
- Working with VBA subprocedures and function procedures
- Incorporating event-handling and interactions with other applications
- Building user-friendly toolbars, menus, and help systems
- Manipulating files and Visual Basic components
- Understanding class modules
- Managing compatibility issues
Feel the power of VBA and Excel
No one can uncover Excel’s hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user’s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you’re fairly new to Excel programming, here’s the foundation you need. If you’re already a VBA veteran, you can start mining a rich lode of programming ideas right away.
About the Author
John Walkenbach is a leading authority on spreadsheet software and is principal of JWalk and Associates Inc., a small San Diego-based consulting firm that specializes in spreadsheet application development. John is the author of more than 30 spreadsheet books and has written more than 300 articles and reviews for a variety of publications, including PC World, InfoWorld, Windows, and PC/Computing. He also maintains The Spreadsheet Page, a popular Internet Web site, and is the developer of Power Utility Pak, an award-winning add-in for Microsoft Excel. John graduated from the University of Missouri and earned a masters degree and a Ph.D. from the University of Montana.
In this Book
-
Excel 2003: Where It Came From
-
Excel in a Nutshell
-
Formula Tricks and Techniques
-
Understanding Excel's Files
-
What is a Spreadsheet Application?
-
Essentials of Spreadsheet Application Development
-
Introducing Visual Basic for Applications
-
VBA Programming Fundamentals
-
Working with VBA Sub Procedures
-
Creating Function Procedures
-
VBA Programming Examples and Techniques
-
Custom Dialog Box Alternatives
-
Introducing UserForms
-
Userform Examples
-
Advanced UserForm Techniques
-
Developing Excel Utilities with VBA
-
Working with Pivot Tables
-
Working with Charts
-
Understanding Excel's Events
-
Interacting with Other Applications
-
Creating and Using Add-Ins
-
Creating Custom Toolbars
-
Creating Custom Menus
-
Providing Help for Your Applications
-
Developing User-Oriented Applications
-
Compatibility Issues
-
Manipulating Files with VBA
-
Manipulating Visual Basic Components
-
Understanding Class Modules
-
Frequently Asked Questions about Excel Programming
