Microsoft® Office Excel® 2007 Visual Basic® for Applications Step by Step

Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!

Create macros to automate repetitive tasks
Automatically format charts, shapes, and text
Manipulate tables and other objects—even build PivotTable reports
Write your own functions and procedures
Use loops and conditions to add decision logic to macros
Build custom command buttons, dialog boxes, and user forms

Your all-in-one learning experience includes:

Files for building skills and practicing the book’s lessons
Fully searchable eBook
Windows Vista® Product Guide eReference—plus other resources on CD

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Customer Reviews:

This book is a mess!

By A. M. Rosa "A. M. Rosa" - November 6, 2008

I don't quite understand how this book got out of the proof-reading and technical review phase and made it to press. There are so many errors in the code and approaches that don't work, that a true beginner to VBA for Excel could easily get lost.

I would want to say that this book is an okay starting point for learning VBA, but I would be afraid that a beginner would get hopelessly confused. I think a better book for learning Excel VBA is VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) by Bill Jelen and Tracy Syrstad.

While I am sure Mr. Jacobson is probably a decent developer and a nice person, he is a sloppy author. He relies too heavily on recording macros and then reworking them to try and teach VBA coding than actually taking the time to explain coding theory and getting you to think how to tackle the problems on your own. Even the fact that he has you type the code... read more

Good book

By Jim - January 11, 2013

Good book. Easy to use. This program is stupid. I don't need to write a paragraph, but the dumb thing won't take until you put in 20 or more words. So I'm not going to bother rating anything any more. I have better things to do than play with my damn computer.

Good Step by Step

By Backbutton "Notify, Confirm & Assure" - November 23, 2012

Had previous versions of this book, so is a rehash of the old. Good examples to follow step by step.

AVAILABILITY
Merchant	Format	Price
Amazon US	Paperback	$7.94 - $29.99
eBooks.com	Digital (PDF)	$23.99
BookByte	Paperback	$22.49
eCampus	Paperback	~~$25.49~~ discount!