Excel VBA Macro Programming

Excel VBA Macro Programming

McGraw-Hill/Osborne | 2004 Year | CHM | 6.32 Mb | 319 Pages

“This unique book presents sample code for more than twenty practical, high-powered Excel VBA macro applications. You get all the essentials of VBA, then explore ways to power Excel with VBA.

Develop powerful, custom Excel applications using Visual Basic for Applications Maximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, you’ll find complete details on Excel VBA programming and application development--from the fundamentals to advanced techniques. Then, you’ll get 21 real-world projects, complete with working code, so you can create Excel VBA macros right away. These projects include everything from setting up timed events to auto totaling a matrix of numbers to altering the appearance of spreadsheet components--and much more.

Write and debug VBA code

Create custom dialog boxes and toolbars

Take advantage of the Excel object model

Write code to interact with a database

Use application programming interface (API) calls

Create and use class modules

Develop unique menus within the Excel menu structure

Expand calculation and search functions

Write macros for customized worksheets

Create full-fledged Excel add-ins

ABOUT THE AUTHOR: Richard Shepherd has been developing software for blue-chip corporations for 20 years. He has produced VBA code in Excel for major projects, including profit-and-loss reporting and business planning and budgeting. ”