Excel VBA Programming For Dummies

Front Cover
John Wiley & Sons, Feb 6, 2013 - Computers - 408 pages
0 Reviews

Take control of your spreadsheets and use VBA to create your own custom Excel applications

Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling 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.

  • Introduces you to a wide array of new Excel 2013 options, beginning with the most important tools and operations for the Visual Basic Editor
  • Provides an overview of the essential elements and concepts for programming with Excel, including using VBA to customize your applications and automate functions
  • Shares techniques for handling errors, debugging, working with range objects, controlling flow, and much more
  • Zeroes in on creating custom dialog boxes, toolbars, and menus

Add a personal touch to your spreadsheets and present your data the way you want with Excel VBA Programming For Dummies, 3rd Edition.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

How VBA Works with Excel 31
91
Working with Range Objects
115
Using VBA and Worksheet Functions
129
Controlling Program Flow and Making Decisions
143
Automatic Procedures and Events
163
Essential VBA Language Elements 93 Chapter 8 Working with Range Objects 115 Chapter 9 Using VBA and Worksheet Functions 129 Chapter 10 C...
183
Bug Extermination Techniques
197
Bug Extermination Techniques 197 Chapter 14 VBA Programming Examples
209
Accessing Your Macros through the User Interface
307
Accessing Your Macros through the User Interface 307 Part V Putting It All Together
327
Creating Worksheet Functions and Living to Tell about It 329 Chapter 21 Creating Excel AddIns
347
Getting Started with Excel VBA Programming 9
365
Ten VBA Questions and Answers 361 Chapter 23 Almost Ten Excel Resources 365 Chapter 24 Ten VBA Dos and Donts
369
Ten VBA Dos and Donts
379
Index
3
How VBA Works with Excel
31

Introduction 1
232
Communicating with Your Users
232
UserForm Basics
249
Using UserForm Controls
265
Using UserForm Controls 265 Chapter 18 UserForm Techniques and Tricks
283
Introducing the Excel Object Model
53
VBA Sub and Function Procedures
67
Using the Excel Macro Recorder
79
Copyright

Other editions - View all

Common terms and phrases

About the author (2013)

John Walkenbach, known to his fans as Mr. Spreadsheet, has written some 50 books and around 300 articles on computer topics, predominantly Excel. He created the award-winning Power Utility Pak and several other versatile Excel add-ons. John maintains the Spreadsheet Page at http://spreadsheetpage.com.

Bibliographic information