Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))

By Reed Jacobson

Teach yourself how to use Microsoft(R) Visual Basic(R) for Applications (VBA) to take command of Microsoft Excel Version 2002. Choose your own best starting point in this self-paced guide to learn how to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more. Easy-to-follow lessons with real-world scenarios and examples show you exactly how to maximize the built-in programming power in Microsoft Excel 2002. Numerous screenshots and a CD full of practice files help you master step-by-step programming procedures. Find out how to create custom solutions with Microsoft Excel and this book--then keep it nearby as an ongoing desktop reference to VBA functions and features. Learn at your own pace how to: Use macros to automate simple and complex tasks Manipulate workbooks and worksheetsExplore range objectsWork with graphical objectsBuild and manipulate PivotTable(R) objectsCreate loops and conditional statements with Visual BasicUse dialog box controls on worksheetsCreate and use custom functions and handle macro errorsCreate custom toolbar buttons, menu commands, command buttons, event handlers, and dialog boxesFor customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook. This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0735613591
• ISBN13: 9780735613591
• Release Date: October 2001
• Publisher: Microsoft Press
• Length: 336 Pages
• Weight: 1.65 lbs.
• Dimensions: 1.0" x 7.3" x 9.3"

Customer Reviews

Great tool to learn VBA

I've taught VBA for a few years, and this book is fantastic. If you are trying to learn VBA from the position of an intermediate Excel user, it is a GREAT way to do so. The extensive coverage of the range object is invaluable, as is the coverage on VBA's debugging tools. I've even recommended this book to Access students just to get a better handle on how to use the VBA debugging tools, because the topic is so well covered!...

There is no better book to teach and learn VBA for Excel

Although this book is indeed introductory and would not qualify as a reference manual it is the best resource that I have found to teach VBA object programming to my students. The examples are great and with the exception of Chapter 6 on Pivot Tables, maybe too difficult for a beginner, I agree with the good reviews of this book.

Jacobson is clear and concise for learning the Range Object

I read this book two editions ago and it helped me convert all the workbooks for a large California bank from Lotus and older Excel formats. The book teaches you to use the Range object which is the main Object in Excel. Once you know it you can do most things with a little help from the great macro recording facility of Excel--you just generalize a few terms and apply your new knowledge of the Range Object. Thank you Reed!...

Outstanding resource

The easy to understand text and practical examples in the book have enabled me to really exploit the potential of Excel. Reed really understands the nuts and bolts of the application and communicates that to the reader.

Very accessible and useful book

I have had bad luck with most programming books. I bought this one as a VBA reference to fill in the blanks of some of the others. This is by far the best programming book I have ever read, and the first one that I read cover to cover. Not only does this book provide the intuition and practical examples, it does so in a readable and accessible fashion. With it I not only improved my programming skills, but learned some Excel...