Excel 2010 Power Programming with VBA

by Walkenbach, John

• ISBN13: 9780470475355
• ISBN10: 0470475358
• Edition: 1st
• Format: Paperback
• Copyright: 2010-05-10
• Publisher: Wiley

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.

Author Biography

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

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.