9780470475355

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.

Michael Murphy is a psychoanalyst with a busy practice in Dublin. He is also an award-winning senior television producer/director and newscaster, and a lecturer in Vincent's University Hospital and University College, Dublin. In 1990 he wrote "Reading the Poems" for Desmond Egan---the Poet and his Work, edited by Professor Hugh Kenner. In 1998 he wrote a book-length study, The Road to the World, a Lacanian analysis of Desmond Egan's collection, A Song for My Father.
John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include John Walkenbach's Favorite Excel 2010 Tips & Tricks, Excel 2010 Formulas, and the bestselling Excel Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com

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.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Excel 2010 Power Programming with VBA

Excel 2010 Power Programming with VBA

0470475358

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review