Excel 2007 Power Programming with VBA

  • 14h 16m
  • John Walkenbach
  • John Wiley & Sons (US)
  • 2007

No one is better at revealing the secrets of Excel than "Mr. Spreadsheet" himself. This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic for Applications. Excel 2007 has a few new tricks up its sleeve, and John Walkenbach helps you make the most of them all.

You'll learn to customize Excel UserForms, develop new utilities, use VBA with charts and PivotTables, and create event-handling applications. Work with VBA subprocedures and function procedures, facilitate interactions with other applications, build user-friendly toolbars, menus, and help systems, and much more. Get ready to make Excel do your bidding.

Mr. Spreadsheet's POWER TIPS:

Power Tip #1 Create powerful Excel applications

Power Tip #2 Enhance Excel with VBA macros

Power Tip #3 Write event-driven VBA code

Power Tip #4 Understand the new Excel 2007 ribbon

Power Tip #5 Expand Excel's shortcut menus

In this Book

  • Excel 2007—Where It Came From
  • Excel in a Nutshell
  • Formula Tricks and Techniques
  • Understanding Excel's Files
  • What Is a Spreadsheet Application?
  • Essentials of Spreadsheet Application Development
  • Introducing Visual Basic for Applications
  • VBA Programming Fundamentals
  • Working with VBA Sub Procedures
  • Creating Function Procedures
  • VBA Programming Examples and Techniques
  • Custom Dialog Box Alternatives
  • Introducing UserForms
  • UserForm Examples
  • Advanced UserForm 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
  • Working with the Ribbon
  • Working with Shortcut Menus
  • Providing Help for Your Applications
  • Developing User-Oriented Applications
  • Compatibility Issues
  • Manipulating Files with VBA
  • Manipulating Visual Basic Components
  • Understanding Class Modules
  • Working with Colors
  • Frequently Asked Questions about Excel Programming
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Microsoft Excel Professional 2021 Guide: A Complete Excel Reference, Loads of Formulas and Functions, Shortcuts, and Numerous Screenshots to Become an Excel Expert
Course Getting started in Excel 365 (2023)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Book Microsoft Excel In Easy Steps: Illustrated Using Excel in Office 365