2012 Puddly Awards
 
 
Follow us on TwitterFollow us on FacebookFollow us on TumblrSubscribe to RSS

Recently Viewed clear list

Original Essays | February 8, 2012

Kent Hartman: IMG A Raider by Any Other Name

1 comment By Kent Hartman

Perhaps you are aware of the fact that there is an oddly popular trivia game floating around that a group of clever (and likely bored) college... Continue »
  1. $18.19 Sale Hardcover add to wish list

    The Wrecking Crew: The Inside Story of Rock and Roll's Best-Kept Secret

    Kent Hartman 9780312619749
spacer
Free Shipping!

Ships free on qualified orders.
$24.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside - Bldg. 2 Microsoft Windows- Applications
1 Local Warehouse Personal Computers- Desktop Applications- Spreadsheets
25 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

eBook editions

Excel 2007 VBA Programming for Dummies (For Dummies)

by John Walkenbach

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

back to top

About the Author

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

Table of Contents

Introduction.

Part I: Introducing VBA.

Chapter 1: What Is VBA?

Chapter 2: Jumping Right In.

Part II: How VBA Works with Excel.

Chapter 3: Working In the Visual Basic Editor.

Chapter 4: Introducing the Excel Object Model.

Chapter 5: VBA Sub and Function Procedures.

Chapter 6: Using the Excel Macro Recorder.

Part III: Programming Concepts.

Chapter 7: Essential VBA Language Elements.

Chapter 8: Working with Range Objects.

Chapter 9: Using VBA and Worksheet Functions.

Chapter 10: Controlling Program Flow and Making Decisions.

Chapter 11: Automatic Procedures and Events.

Chapter 12: Error-Handling Techniques.

Chapter 13: Bug Extermination Techniques.

Chapter 14: VBA Programming Examples.

Part IV: Communicating with Your Users.

Chapter 15: Simple Dialog Boxes.

Chapter 16: UserForm Basics.

Chapter 17: Using UserForm Controls.

Chapter 18: UserForm Techniques and Tricks.

Chapter 19: Accessing Your Macros Through the User Interface.

Part V: Putting It All Together.

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

Chapter 21: Creating Excel Add-Ins.

Part VI: The Part of Tens.

Chapter 22: Ten VBA Questions (And Answers)

Chapter 23: (Almost) Ten Excel Resources.

Index.

back to top

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)
report this comment
back to top

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:
2007
Edition Description:
Computers
Series:
For Dummies
Publication Date:
20070220
Binding:
Electronic book text in proprietary or open standard format
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
384
Dimensions:
9.31x7.43x.84 in. 1.25 lbs.
back to top

Other books you might like

  1. $7.95 Used Trade Paper add to wish list

    Empowered Volume 4

    Adam Warren 9782811204761
  2. $16.95 Used Trade Paper add to wish list

    Crystal Reports 10 for Dummies (For Dummies)

    Allen G Taylor 9780764571374
back to top

Related Aisles

Excel 2007 VBA Programming for Dummies (For Dummies) New Trade Paper
0 stars - 0 reviews
$24.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 eBooks — here at Powells.com.