Excel® 2010 Power Programming with VBA

by
Format: eBook
Pub. Date: 2010-04-01
Publisher(s): Wiley
Availability: This title is currently not available.
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $52.49

Rent Book

Select for Price
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

All the methods and tools you need to successfully program with ExcelJohn Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA) Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won't find anywhere else Includes a CD with templates and worksheets from the bookThis power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

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.