Excel 2010 Power Programming with VBA

Name: Excel 2010 Power Programming with VBA
Availability: InStock
ISBN: 9780470475355

ISBN-10: 0470475358

ISBN-13: 9780470475355

Edition: 2010

Authors: John Walkenbach

List price: $82.95

30 day, 100% satisfaction guarantee!

Semester Rental: $19.09 Due date: 8/14/2024

Rental notice: supplementary materials (access codes, CDs, etc.) are not guaranteed with rental orders.

Buy used: $7.22

Alternate versions

No Supplement : $7.22

Marketplace

1 new & used from $4.68

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

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…

Book details

List price: $82.95
Copyright year: 2010
Publisher: John Wiley & Sons, Limited
Publication date: 4/23/2010
Binding: Paperback
Pages: 1088
Size: 7.30" wide x 9.20" long x 2.10" tall
Weight: 3.542
Language: English



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