Excel VBA Macro Programming

Shepherd, Richard

ISBN 10: 0072231440 / ISBN 13: 9780072231441

Published by McGraw-Hill Education, 2004

About this Item

Dispatched, from the UK, within 48 hours of ordering. Though second-hand, the book is still in very good shape. Minimal signs of usage may include very minor creasing on the cover or on the spine.

Seller Inventory # CHL1668627

Bibliographic Details

• Title: Excel VBA Macro Programming
• Publisher: McGraw-Hill Education
• Publication Date: 2004
• Language: English
• ISBN 10: 0072231440
• ISBN 13: 9780072231441
• Binding: Paperback
• Condition: Used; Very Good

About this title

Synopsis

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

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.