text.skipToContent text.skipToNavigation
  1. Home
  2. Business & Economics
  3. FT Press
  4. VBA and Macros: Microsoft Excel 2010

VBA and Macros: Microsoft Excel 2010, 1st edition

  • Bill Jelen
  • Tracy Syrstad

Published by Que Publishing (June 21st 2010) - Copyright © 2011

1st edition

Chosen format
View all
VBA and Macros: Microsoft Excel 2010

ISBN-13: 9780789743688

Includes: Unassigned

This product is not available in your country

What's included

  • Unassigned








Microsoft Excel 2010




Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010’s most powerful new features. Learning advanced Excel scripting has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel.



• Work efficiently with ranges, cells, and R1C1-style formulas

• Build super-fast applications with arrays

• Customize the Excel 2010 Ribbon to run your macros

• Write Excel 2010 VBA code that works on older versions of Excel

• Create custom dialog boxes to collect information from your users

• Use error handling to make your VBA scripts more resilient

• Use Web queries to import data from virtually any online source

• Master advanced techniques such as classes and collections

• Use Excel VBA to control other Office programs…even control Windows itself,

via the Windows API

• Create add-ins to share or sell your programs


About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will


• Dramatically increase your productivity—saving you 50 hours a year or more

• Present proven, creative strategies for solving real-world problems

• Show you how to get great results, no matter how much data you have

• Help you avoid critical mistakes that even experienced users make



Table of contents


Chapter 1 Unleash the Power of Excel with VBA

The Power of Excel

Barriers to Entry

    The Macro Recorder Doesn’t Work

    Visual Basic Is Not Like BASIC

    Good News: Climbing the Learning Curve Is Easy

    Great News: Excel with VBA Is Worth the Effort

Knowing Your Tools: The Developer Tab

Macro Security

    Adding a Trusted Location

    Using Macro Settings to Enable Macros in Workbooks Outside of Trusted Locations

    Using Disable All Macros with Notification

Overview of Recording, Storing, and Running a Macro

    Filling Out the Record Macro Dialog

Running a Macro

    Creating a Macro Button on the Ribbon

    Creating a Macro Button on the Quick Access Toolbar

    Assigning a Macro to a Form Control, Text Box, or Shape

Using New File Types in Excel 2010

Understanding the VB Editor

    VB Editor Settings

    The Project Explorer

    The Properties Window

Understanding Shortcomings of the Macro Recorder

    Examining Code in the Programming Window

    Running the Macro on Another Day Produces Undesired Results

    Possible Solution: Use Relative References When Recording

    Never Use the AutoSum Button While Recording a Macro

    Three Tips When Using the Macro Recorder

Next Steps

Chapter 2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar?

I Can’t Understand This Code

Understanding the Parts of VBA “Speech”

VBA Is Not Really Hard

    VBA Help Files: Using F1 to Find Anything

    Using Help Topics

Examining Recorded Macro Code: Using the VB Editor and Help

    Optional Parameters

    Defined Constants

    Properties Can Return Objects

Using Debugging Tools to Figure Out Recorded Code

    Stepping Through Code

    More Debugging Options: Breakpoints

    Backing Up or Moving Forward in Code

    Not Stepping Through Each Line of Code

    Querying Anything While Stepping Through Code

    Using a Watch to Set a Breakpoint

    Using a Watch on an Object

Object Browser: The Ultimate Reference

Seven Tips for Cleaning Up Recorded Code

    Tip 1: Don’t Select Anything</

For teachers

All the material you need to teach your courses.

Discover teaching material