
Excel® 2010 Power Programming with VBA
by John Walkenbach (J-Walk and Associates, Inc., San Diego, CA )-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
Rent Book
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
Summary
Table of Contents
Introduction | |
Some Essential Background | |
Excel 2010: Where It Came From | |
Excel in a Nutshell | |
Formula Tricks and Techniques | |
Understanding Excel Files | |
Excel Application Development | |
What Is a Spreadsheet Application? | |
Essentials of Spreadsheet Application Development | |
Understanding Visual Basic for Applications | |
Introducing Visual Basic for Applications | |
VBA Programming Fundamentals | |
Working with VBA Sub Procedures | |
Creating Function Procedures | |
VBA Programming Examples and Techniques | |
Working with UserForms | |
Custom Dialog Box Alternatives | |
Introducing UserForms | |
UserForm Examples | |
Advanced UserForm Techniques | |
Advanced Programming 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 | |
Developing Applications | |
Working with the Ribbon | |
Working with Shortcut Menus | |
Providing Help for Your Applications | |
Developing User-Oriented Applications | |
Other Topics | |
Compatibility Issues | |
Manipulating Files with VBA | |
Manipulating Visual Basic Components | |
Understanding Class Modules | |
Working with Colors | |
Frequently Asked Questions about Excel Programming | |
Appendixes | |
Excel Resources Online | |
VBA Statements and Functions Reference | |
VBA Error Codes | |
What's on the CD-ROM | |
Index | |
End-User License Agreement | |
Table of Contents provided by Publisher. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.