Pub. Date:
McGraw-Hill Professional Publishing
Excel VBA Macro Programming / Edition 1

Excel VBA Macro Programming / Edition 1

by Richard ShepherdRichard Shepherd


Current price is , Original price is $34.0. You

Temporarily Out of Stock Online

Please check back later for updated availability.

16 New & Used Starting at $1.99


Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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

Product Details

ISBN-13: 9780072231441
Publisher: McGraw-Hill Professional Publishing
Publication date: 01/14/2004
Series: In-Depth Programming and Web Development Series
Pages: 320
Product dimensions: 7.40(w) x 9.20(h) x 0.69(d)

About the Author

Richard Shepherd (Reading, Berkshire, England) is a qualified accountant with a special interest in computer languages, particularly Visual Basic, and he’s spent the last 20 years developing computer software in blue chip organizations.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Excel VBA Macro Programming 4 out of 5 based on 0 ratings. 2 reviews.
Anonymous More than 1 year ago
Guest More than 1 year ago
An excellent book. This has opened up a whole new dimension to Excel and shown me how to write very effective code. Following the book, I have even created my own professional add in. I was amazed how well it works - my friends are very impressed! Plenty of examples to follow and copy in which all work. They go from easy to complicated e.g. adding row and column totals onto a selected matrix of numbers with a single click. The book is easy to follow and is well written.