Excel 2007 Power Programming with VBA
- 14h 16m
- John Walkenbach
- John Wiley & Sons (US)
- 2007
No one is better at revealing the secrets of Excel than "Mr. Spreadsheet" himself. This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic for Applications. Excel 2007 has a few new tricks up its sleeve, and John Walkenbach helps you make the most of them all.
You'll learn to customize Excel UserForms, develop new utilities, use VBA with charts and PivotTables, and create event-handling applications. Work with VBA subprocedures and function procedures, facilitate interactions with other applications, build user-friendly toolbars, menus, and help systems, and much more. Get ready to make Excel do your bidding.
Mr. Spreadsheet's POWER TIPS:
Power Tip #1 Create powerful Excel applications
Power Tip #2 Enhance Excel with VBA macros
Power Tip #3 Write event-driven VBA code
Power Tip #4 Understand the new Excel 2007 ribbon
Power Tip #5 Expand Excel's shortcut menus
In this Book
-
Excel 2007—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
-
Working with the Ribbon
-
Working with Shortcut Menus
-
Providing Help for Your Applications
-
Developing User-Oriented Applications
-
Compatibility Issues
-
Manipulating Files with VBA
-
Manipulating Visual Basic Components
-
Understanding Class Modules
-
Working with Colors
-
Frequently Asked Questions about Excel Programming
