BN.com Gift Guide

Overview

Step-by-step instructions for creating VBA macros

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it ...

See more details below
Excel 2007 VBA Programming For Dummies

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$16.49
BN.com price
(Save 45%)$29.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

Step-by-step instructions for creating VBA macros

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.

Discover how to

  • Grasp essential programming concepts
  • Use the Visual BasicĀ® Editor
  • Navigate the new Excel user interface
  • Communicate with your users
  • Deal with errors and bugs
Read More Show Less

Product Details

  • ISBN-13: 9781118050804
  • Publisher: Wiley
  • Publication date: 2/8/2011
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 384
  • Sales rank: 775,634
  • File size: 12 MB
  • Note: This product may take a few minutes to download.

Meet the Author

John Walkenbach is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak.
Read More Show Less

Table of Contents

Introduction 1

Part I: Introducing VBA 9

Chapter 1: What Is VBA? 11

Chapter 2: Jumping Right In 21

Part II: How VBA Works with Excel 33

Chapter 3: Working In the Visual Basic Editor 35

Chapter 4: Introducing the Excel Object Model 53

Chapter 5: VBA Sub and Function Procedures 67

Chapter 6: Using the Excel Macro Recorder 79

Part III: Programming Concepts 91

Chapter 7: Essential VBA Language Elements 93

Chapter 8: Working with Range Objects 113

Chapter 9: Using VBA and Worksheet Functions 125

Chapter 10: Controlling Program Flow and Making Decisions 139

Chapter 11: Automatic Procedures and Events 157

Chapter 12: Error-Handling Techniques 177

Chapter 13: Bug Extermination Techniques 191

Chapter 14: VBA Programming Examples 203

Part IV: Communicating with Your Users 221

Chapter 15: Simple Dialog Boxes 223

Chapter 16: UserForm Basics 239

Chapter 17: Using UserForm Controls 255

Chapter 18: UserForm Techniques and Tricks 275

Chapter 19: Accessing Your Macros Through the User Interface 299

Part V: Putting It All Together 315

Chapter 20: Creating Worksheet Functions and Living to Tell about It 317

Chapter 21: Creating Excel Add-Ins 333

Part VI: The Part of Tens 345

Chapter 22: Ten VBA Questions (And Answers) 347

Chapter 23: (Almost) Ten Excel Resources 351

Index 355

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 13 Customer Reviews
  • Posted October 10, 2009

    I Also Recommend:

    Good book for what it is

    This truly is the "For Dummies" version of VBA programming. If you've done programming in VBA before with no help but the internet and maybe other peoples code this book really has little to teach you. If you've never seen or written VBA before this is the book to help you get started.

    If you want more advanced VBA training I recommend Professional Excel Development or Power Programming with VBA.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 15, 2013

    No text was provided for this review.

  • Anonymous

    Posted August 2, 2009

    No text was provided for this review.

  • Anonymous

    Posted February 5, 2010

    No text was provided for this review.

  • Anonymous

    Posted July 15, 2009

    No text was provided for this review.

  • Anonymous

    Posted September 26, 2009

    No text was provided for this review.

  • Anonymous

    Posted March 5, 2010

    No text was provided for this review.

  • Anonymous

    Posted January 29, 2010

    No text was provided for this review.

  • Anonymous

    Posted June 26, 2010

    No text was provided for this review.

  • Anonymous

    Posted June 17, 2010

    No text was provided for this review.

  • Anonymous

    Posted February 5, 2009

    No text was provided for this review.

  • Anonymous

    Posted June 14, 2010

    No text was provided for this review.

  • Anonymous

    Posted July 1, 2010

    No text was provided for this review.

Sort by: Showing all of 13 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)