Jump to ratings and reviews
Rate this book

Excel VBA Macro Programming

Rate this book
Publisher's 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 codeCreate custom dialog boxes and toolbarsTake advantage of the Excel object modelWrite code to interact with a databaseUse application programming interface (API) callsCreate and use class modulesDevelop unique menus within the Excel menu structureExpand calculation and search functionsWrite macros for customized worksheetsCreate full-fledged Excel add-ins




320 pages, Paperback

First published January 5, 2004

Loading...
Loading...

About the author

Richard Shepherd

40 books8 followers

Ratings & Reviews

What do you think?
Rate this book

Friends & Following

Create a free account to discover what your friends think of this book!

Community Reviews

5 stars
3 (17%)
4 stars
3 (17%)
3 stars
7 (41%)
2 stars
4 (23%)
1 star
0 (0%)
No one has reviewed this book yet.