Product Description

By itself, Excel 97 can do some pretty amazing stuff. Add Visual Basic for Applications (VBA) and you add a whole other dimension of automation and customization. Excel 97 Programming For Windows For Dummies offers plenty of practical examples of Excel programming in action and explains in plain English how to
∗ Save time and improve accuracy by automating common tasks
∗ Design custom dialog boxes to suit your and your organization′s needs
∗ Build specialized functions to use in your worksheets
∗ Create add–ins, take advantage of the Windows API, and define custom data types
With numerous books and articles on Excel to his credit, John Walkenbach is the ideal author to make Excel programming understandable, whether you′re new to programming or just new to this latest release of Excel.

Product Details

• Amazon Sales Rank: #481479 in Books
• Published on: 1997-06-19
• Original language: English
• Number of items: 1
• Binding: Paperback
• 300 pages

From the Back Cover
Tips and tricks for writing powerful macros with VBA!

Your first aid kit^® for designing user–friendly applications

Find out how to create custom dialog boxes, toolbars, menus, and more! If you want to write programs that perform time–consuming procedures in a snap, then this is the book for you! Inside you'll find explanations on how Visual Basic for Applications works with Excel, how–to guidance on Visual Basic Editor, and tried–and–true tips to help you write and run some really cool macros.

Discover how to: Make your VBA code run with speed Enhance spreadsheet functionality Create custom add–ins Modify an objects properties Debug your applications Add online help features to worksheets

The Dummies Way^™ Explanations in plain English "Get in, get out" information Icons and other navigational aids Tear–out cheat sheet Top ten lists A dash of humor and fun

Get smart! www.dummies.com Register to win cool prizes Browse exclusive articles and excerpts Get a free Dummies Daily^™ e–mail newsletter Chat with authors and preview other books Talk to us, ask questions, get answers

About the Author
John Walkenbach has written hundreds of articles and numerous books, including Microsoft?? Excel 2000 Formulas. He is the principal of JWalk Associates, a spreadsheet application development company.

Customer Reviews

I aint no dummy but this book is worth the stigma.
...The book is very clear to understand and full of advice and tips. You don't need to read it from cover to cover as the index is very good when your looking to "iron out" some glitches in macros etc. I have bought various books for VBA programming but some are obviously written by programmers with programmers minds who cannot communicate on laymans terms. John W is definately not one who fits into that category. If the other "Dummies" books are half as clear as this book then it might be worth buying more (I'm currently thinking of buying the Access 97 programmers one), I'll let you know how I get on with the others.

So finally.... get this book, the tricks it teaches are enough to get you a promotion (still waiting for mine though ! - all resonable offers considered.)

The best that the dummies series has to offer
This book and Excel's online help is really all you need. It's packed full of tips and tricks that show you both how to program in VBA and how to use the interface. Although even an experienced VBA developer will benefit from JW's book, it's really aimed at the competent Excel user who's just beginning to get into Excel VBA. This book is like a collection of all the little bits that you would highlight as "worth remembering" in one of those colossal tomes. It is light without being jokey and thorough without being exhausting. All dummies books should be like this one.

Simply fantastic !
I was a bit apprehensive buying yet "another" VBA book, but I was most pleasantly suprised with this. The examples are very basic and very easy to understand. I have to admit that within hours of reading the first few chapters, I was already well under way programming in VBA.

It really is that easy ! This book is a must have for those wanting to learn VBA in Excel 97.