Excel VBA Programming For Dummies®, 2nd Edition

by
Format: eBook
Pub. Date: 2010-04-01
Publisher(s): For Dummies
Availability: This title is currently not available.
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $31.49

Rent Book

Select for Price
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

Take your Excel skills to the next level with VBA programmingNow that you've mastered Excel basics, it's time to move to the next levelcreating your own, customized Excel 2010 solutions using Visual Basic for Applications (VBA). The new edition of this non-threatening guide is your key to getting there. Using step-by-step instruction and the accessible, friendly For Dummies style, this practical book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.The book's Web site provides all the programming examples from the book. Introduces you to a new range of Excel 2010 options Shows you how to use Visual Basic for Applications (VBA) to program your own custom Excel applications or to automate functions Explains how to create VBA macros, program, handle errors, debug, and more Covers Visual Basic Editor tools and functions; working with range objects; controlling program flow; and the easiest ways to create custom dialog boxes, toolbars, and menus Includes a companion Web site with all the sample programs from the bookCreate your own, custom Excel programs with this information-packed guide!

Table of Contents

Introduction
Introducing VBA
What Is VBA?
Jumping Right In
How VBA Works with Excel
Working In the Visual Basic Editor
Introducing the Excel Object Model
VBA Sub and Function Procedures
Using the Excel Macro Recorder
Programming Concepts
Essential VBA Language Elements
Working with Range Objects
Using VBA and Worksheet Functions
Controlling Program Flow and Making Decisions
Automatic Procedures and Events
Error-Handling Techniques
Bug Extermination Techniques
VBA Programming Examples
Communicating with Your Users
Simple Dialog Boxes
UserForm Basics
Using UserForm Controls
UserForm Techniques and Tricks
Accessing Your Macros through the User Interface
Putting It All Together
Creating Worksheet Functions - and Living to Tell about It
Creating Excel Add-Ins
The Part of Tens
Ten VBA Questions (And Answers)
(Almost) Ten Excel Resources
Index
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.