Automotive Holiday Deals Books Gift Guide Books Gift Guide Shop Men's Cyber Monday Deals Week Learn more nav_sap_SWP_6M_fly_beacon Indie for the Holidays egg_2015 All-New Amazon Fire TV Beauty Deals Gifts for Her Amazon Gift Card Offer mithc mithc mithc  Amazon Echo Starting at $49.99 Kindle Voyage R6 Siege Outdoor Deals on HTL

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Mastering VBA for Office 2010 1st Edition

26 customer reviews
ISBN-13: 978-0470634004
ISBN-10: 0470634006
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $9.08
Learn More
Trade in now
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$24.71 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$34.29 On clicking this link, a new layer will be open
More Buying Choices
38 New from $26.27 27 Used from $24.15
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Get Up to 80% Back Rent Textbooks
$34.29 FREE Shipping on orders over $35. Only 17 left in stock (more on the way). Ships from and sold by Gift-wrap available.

Frequently Bought Together

  • Mastering VBA for Office 2010
  • +
  • Excel 2010 Power Programming with VBA
  • +
  • 101 Ready-To-Use Excel Macros
Total price: $87.75
Buy the selected items together

Editorial Reviews

From the Back Cover

Get more done in less time by automating Office tasks

Take control of Office 2010 with Microsoft's Visual Basic for Applications (VBA) and this practical guide. Even if you're not a programmer, you can easily learn to record and write macros, automate tasks, and create your own custom programs for Word, Excel, PowerPoint, Outlook, and Access.

You'll quickly grasp the basics of recording macros with Office 2010's built-in Macro Recorder, before delving into all the essentials: the Visual Basic Editor, VBA syntax, how to use loops and functions, the keys to building effective code, how to debug and secure your code, programming the Office 2010 Ribbon, and much more.

Coverage includes:

  • Recording, writing, and running macros in Office 2010

  • Creating code from scratch with the Visual Basic® Editor

  • Understanding the essentials of VBA syntax

  • Finding the objects, methods, and properties you need

  • Using loops to repeat actions in your code

  • Creating simple and complex dialog boxes

  • Adding If statements to make your applications respond intelligently

  • Programming each Office app—Word, Excel®, PowerPoint®, Outlook®, and Access®

  • Building, debugging, and securing your code

Use VBA to Increase Your Productivity in Office 2010

Simplify Complex Operations with Macros and Automation

Create Custom Apps for Word, Excel, PowerPoint, Outlook, and Access

Reinforce Your Skills with Real-World Examples

Master VBA Fundamentals and Essentials

Create Custom Applications and Macros for Office 2010

About the Author

Richard Mansfield is the author or coauthor of more than 40 computer books, includingVisual Basic .NET Power Toolkit, Office 2003 Application Development All-in-One Desk Reference For Dummies, and Programming: A Beginner's Guide. He is the former editor of Compute! magazine. Overall, his books have sold more than half a million copies worldwide and have been translated into 12 languages.


Product Details

  • Paperback: 912 pages
  • Publisher: Sybex; 1 edition (August 24, 2010)
  • Language: English
  • ISBN-10: 0470634006
  • ISBN-13: 978-0470634004
  • Product Dimensions: 7.4 x 1.7 x 9.3 inches
  • Shipping Weight: 2.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (26 customer reviews)
  • Amazon Best Sellers Rank: #347,937 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

31 of 33 people found the following review helpful By Let's Compare Options Preptorial TOP 500 REVIEWER on August 31, 2012
Format: Paperback Verified Purchase
What 1,000 page programming guide can you get new for under $30? OK, this covers ALL the office applications, and you might wonder if it would be better to learn macros and Visual Basic program by program. That depends on your needs. If all you ever do is Excel or Word, you could pay $30 or more for just ONE of those applications of macros/VBA, and get a LITTLE more depth in terms of specific examples.

BUT-- here's an idea. GET THIS BOOK INSTEAD. It covers all the Office applications, and by the time you've scanned it, you'll have a really good feel for the whole field of VB as applied to customizing office tools. THEN, if, for example, you want to know how to script or record a macro that will convert hyperlinks to end notes in Word, just Google that phrase, and use this reference/text to figure out what the web is telling you to do for that specific task.

With Windows 8 coming out and Office 2013 to 2020 etc., it this a good time to buy this book? An unqualified YES. The VB code and macro recording info are backward compatible to 07 and forward compatible indefinitely. Why? Because the script IS script, and Microsoft has made a 20 year commitment to OOP, including both C# and VB. They are still writing their programs in both as we speak! I'm a developer on the search side of C#, and all their advanced info shows a continuing commitment to both platforms, so don't fret the usual out of date before it's printed routine (although you are smart to wonder about it!).

Very well contented and indexed, so you can use it both as a study guide and reference.
Read more ›
3 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
19 of 21 people found the following review helpful By Carol Zellner on January 19, 2013
Format: Paperback Verified Purchase
Being a newbie to VBA, I was trying to understand the structure of VBA and then move on to learning the specific commands. This book moves rapidly into commands and it left me wanting to understand the basics better. Although the editor in Office programs gives you hints as to what the appropriate sequences might be, it's still unclear to me. Even after creating many subroutines successfully, I still feel like I'm walking around in the dark. I kept hoping that I'd see the light once I did more of it but that's not the case. I do find myself referring to the book frequently but without web searches, I would have been unable to the work I needed successfully using only this book. There is a lot in the book in that it covers all office applications and is reasonably priced, however, that matters not if you can't get a solid understanding of the fundamentals. I'm looking for something better. It would be helpful to understand when some of the commands would be used and why. A single example is inadequate to really understand what a command can do.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
15 of 18 people found the following review helpful By The Vanishing Turkey on July 13, 2011
Format: Paperback Verified Purchase
I was a little apprehensive at first because programming books are often much more expensive than this but I am pleased with the information in it. The author does a great job of not only informing the reader of how to program, but what practices are useful in making programming easier. It is easy to see after each chapter that you are making progress, yet I felt I didn't have to wade through all that information. All in all, very happy with this book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
5 of 5 people found the following review helpful By Tom G on September 8, 2013
Format: Paperback Verified Purchase
I had been writing my own VBA programs for Excel and was looking to learn more in that application. I was drawn to this book because it was one of the few that addressed the entire Microsoft Office suite; and at the same price as an Excel centric book I figured it would be a good investment. I began flipping through the book looking for quick examples that could get me going. Not finding what I was looking for my first impression was the book was more of a high level overview and not one that would give me the deep knowledge I was looking for. Was I ever wrong! I don't have much patience for reading a technical manual of this size but once I committed to reading from the front cover forward I quickly learned that this book was in fact the tool that I was searching for. The author painstakingly presents real world examples of VBA code and then describes each step with great clarity. You will learn good programming practices that make the user experience easier and of greater value. You will also gain a true appreciation for proper commenting and structure so that if in the future you or someone else has to modify the code it will be familiar and easy to do so.

From a presentation perspective the text sizes and examples are very small and can be difficult to read but the alternative is to create a book that could easily double in page count and cost. I believe that for this book it was worth my squinting a little more than usual. Some additional examples would also be helpful but how much can you honestly expect to be packed into a single book? Maybe a companion workbook would be a good suggestion for the author.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
9 of 11 people found the following review helpful By Chris Einarsen on December 21, 2012
Format: Paperback Verified Purchase
It begins by assuming nothing so it is good from a novice or revision point of view.
The language is excellent -i.e. not too technical.
Print and layout makes for easy reading.
IT lays out VBA for all the Microsoft Office applications and clearly defines each task to be done.
There is some reading to be done but it is excellently interspersed with small tasks.
One criticism is that the font size is too small. To make it larger would make the 'tome' too unwieldy. This criticism is more to do with my age I think! I have a magnifying glass close at hand.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Mastering VBA for Office 2010
This item: Mastering VBA for Office 2010
Price: $34.29
Ships from and sold by

Want to discover more products? Check out these pages to see more: presentation folder design, vba application, macros for microsoft office, vba for word, access vba, learn microsoft access,excel