Poetry Madness
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Interviews | March 9, 2015

    Rhianna Walton: IMG Erik Larson: The Powells.com Interview



    Erik LarsonI've been a fan of Erik Larson's riveting brand of narrative history for years, and his latest book, Dead Wake: The Last Crossing of the Lusitania,... Continue »
    1. $19.60 Sale Hardcover add to wish list

    spacer
Qualifying orders ship free.
$29.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside Microsoft Windows- Applications
3 Local Warehouse Personal Computers- Desktop Applications- Spreadsheets
4 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Excel 2007 VBA Programming for Dummies (For Dummies)

by

Excel 2007 VBA Programming for Dummies (For Dummies) Cover

ISBN13: 9780470046746
ISBN10: 0470046740
All Product Details

 

Synopses & Reviews

Publisher Comments:

To take Excel to the next level, users need to understand and implement the power of Visual Basic for Applications (VBA). Excel  2007 VBA Programming For Dummies introduces readers to a wide array of new Excel options, including  the redesigned Excel user inteface.  Excel  2007 VBA Programming For Dummies begins with getting readers well acquainted with the most important tools and operations for the Visual Basic Editor. There is an overview of the essential elements and concepts for programming with Excel. Discover techniques for handling errors and exterminating bugs, the basics of working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes and how to create custom toolbars and menus, readers are soon creating Excel applications that are custom fit to their unique needs.

Synopsis:

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(r) Editor

* Navigate the new Excel user interface

* Communicate with your users

* Deal with errors and bugs

Synopsis:

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

About the Author

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

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

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

venkat1360, April 12, 2007 (view all comments by venkat1360)
An extremely very good book, which ensured that I am not a dummy anymore...especially in vba or in excell.
Was this comment helpful? | Yes | No
(12 of 20 readers found this comment helpful)

Product Details

ISBN:
9780470046746
Author:
Walkenbach, John
Publisher:
For Dummies
Revised by:
Pieterse, Jan Karel
Revised:
Pieterse, Jan Karel
Author:
Pieterse, Jan Karel
Subject:
Business
Subject:
Spreadsheets - General
Subject:
Spreadsheets - Excel
Subject:
Computer programs
Subject:
Electronic spreadsheets
Subject:
Business -- Computer programs.
Subject:
Microsoft Excel
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
For Dummies
Publication Date:
20070220
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
384
Dimensions:
9.31x7.43x.84 in. 1.25 lbs.

Other books you might like

  1. Empowered Volume 4 Used Trade Paper $7.95
  2. Crystal Reports 10 for Dummies (For...
    Used Trade Paper $4.50

Related Subjects

» BLOCKED
» Computers and Internet » Computer Languages » Visual Basic
» Computers and Internet » Operating Systems » Microsoft Windows » Applications
» Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
» Computers and Internet » Software Engineering » Programming and Languages
» Health and Self-Help » Health and Medicine » General
» Health and Self-Help » Health and Medicine » General Medicine
» History and Social Science » World History » General
» Science and Mathematics » Environmental Studies » General

Excel 2007 VBA Programming for Dummies (For Dummies) New Trade Paper
0 stars - 0 reviews
$29.99 In Stock
Product details 384 pages For Dummies - English 9780470046746 Reviews:
"Synopsis" by , 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(r) Editor

* Navigate the new Excel user interface

* Communicate with your users

* Deal with errors and bugs

"Synopsis" by , 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

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.