Excel 2000 Programming for Dummies [Paperback]

John Walkenbach (Author), Allen L. Wyatt Sr. (Author)

Book Description

ISBN-10: 0764505661 | ISBN-13: 978-0764505669 | Publication Date: August 5, 1999

If you're ready to take the next step with Excel, then look no further. By using VBA (Visual Basic Application), you can discover a side of Microsoft Excel that most users never uncover. Excel 2000 Programming For Dummies introduces you to a wide array of new Excel options, including options for creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; and doing much more.

First, you get well-acquainted with the most important tools and operations for the Visual Basic Editor; then, you get a quick overview of the essential elements and concepts for programming with Excel. Discover techniques for handling errors and exterminating bugs, the basics of working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes (also known as UserForms) and create custom toolbars and menus, you'll soon be creating the interfaces that best suit your unique needs.

By the time you rip through Excel 2000 Programming For Dummies, you'll not only have maximized your macros, you'll have moved on to creating Excel applications with the best programmers on the block.

Editorial Reviews

About the Author

John Walkenbach is one of the country's leading authorities on spreadsheet software. He's principal of Jwalk and Associates Inc., a Southern California-based consulting firm that specializes in spreadsheet application development. John is also a shareware developer, and his most popular product is the Power Utility Pak add-in for Excel. John has written more than 250 articles and reviews for publications such as PC World, InfoWorld, Windows, and PC/Computing. In addition, he's authored more than 20 other spreadsheet books, including Excel 97 Bible, Excel 97 For Windows For Dummies Quick Reference, and Excel 97 Programming For Windows For Dummies. jwalk.com). When he's not banging away on his computer keyboard, he's probably banging away on one of his guitars, trying to cop a few blues licks from Freddie King.

Product Details

• Paperback: 408 pages
• Publisher: For Dummies (August 5, 1999)
• Language: English
• ISBN-10: 0764505661
• ISBN-13: 978-0764505669
• Product Dimensions: 9.1 x 7.4 x 0.9 inches
• Shipping Weight: 1.5 pounds (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #1,382,110 in Books (See Top 100 in Books)

More About the Author

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the foremost authority on Excel. His fifty-plus books include Excel 2010 Power Programming with VBA, Excel 2010 Formulas, and the bestselling Excel 2010 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pak.

Customer Reviews

Most Helpful Customer Reviews

29 of 29 people found the following review helpful:

5.0 out of 5 stars Great tool for learning advanced features in Excel, May 25, 2000

By 

D. Wetzel - See all my reviews
(REAL NAME)   

This review is from: Excel 2000 Programming for Dummies (Paperback)

This is a great book for learning the really fancy features of Microsoft Excel. Many other books are just a reference for this sort of material, or they barely touch on some of the programming features. This book goes into great detail about VBA (Visual Basic Editor), which is the reason I bought this book. From there it goes on to talk about how to customize your spreadsheets with toolbars and menus. This is an excellent book on anyone who wants to master Excel.

27 of 29 people found the following review helpful:

5.0 out of 5 stars Surprisingly good, February 7, 2000

By 

B. Skulason (Reykjavik, Iceland) - See all my reviews

This review is from: Excel 2000 Programming for Dummies (Paperback)

I am using this book to teach advanced course in computer useage in a University Business department. It is very comprehensive, has good coverage and useful examples. Its best quality is in choosing: what to include and what to exclude. The most common mistake people make in writing such books is to try to include everything. In this book you learn enough to do something useful and are able to figure out the rest for yourself. And the best part: in not too many pages. To the autor: thank you.

ps. The only drawback is its name, does the "dummies" refer to the students or the teacher?

1 of 1 people found the following review helpful:

4.0 out of 5 stars Great resource, September 14, 2004

By 

A. Negline (Sydney, Australia) - See all my reviews
(REAL NAME)   

This review is from: Excel 2000 Programming for Dummies (Paperback)

This book has been a great help in making me very proficient in Excel 2000 VBA. This book has given me the knowledge to develop some very powerful tools which have helped me dramatically in my business. This book is well written and uses a logical process to describe VBA's features.