Excel VBA Programming For Dummies

Excel VBA Programming For Dummies

Paperback For Dummies

By (author) John Walkenbach

$18.90
List price $34.35
You save $15.45 44% off

Free delivery worldwide
Available
Dispatched in 3 business days
When will my order arrive?

  • Publisher: John Wiley & Sons Inc
  • Format: Paperback | 408 pages
  • Dimensions: 185mm x 231mm x 23mm | 567g
  • Publication date: 5 March 2013
  • Publication City/Country: New York
  • ISBN 10: 1118490371
  • ISBN 13: 9781118490372
  • Edition: 3, Revised
  • Edition statement: 3rd Revised edition
  • Sales rank: 31,910

Product description

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 .

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 10 of 10
Categories:

Author information

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.

Back cover copy

Learn to: Use the essential tools and operations for VBAGet the most out of Excel's macro recording featureHandle errors and eliminate bugs in your codeDevelop custom worksheet functions and user-oriented applicationsExplore VBA programming and learn how to customize and automate many aspects of ExcelMaybe you're eager to learn Excel programming. Maybe it's your boss's idea. Either way, this book will have you on your way to Excel programming perfection in no time! It's a plain-English guide to what VBA is, how it works with Excel, essential programming concepts, and steps to creating some very cool dialog boxes, time-saving macros, Excel add-ins, and more.VBA-speak -- learn the language of VBA and steps for creating a program in ExcelMacro magic -- automate common tasks, create custom buttons and commands, and develop new worksheet functions using VBA macrosProgramming basics -- work with range objects, control program flow, automate procedures and events, and exterminate bugs in your codeUser communication -- explore simple and custom dialog boxes and UserForm controls, tricks, and techniquesAll together now -- apply your skills to design user-oriented applications, create add-ins, and work with other Office applications"Open the book and find: Some Excel history that's good to knowAll about VBA sub and function proceduresHow you can get ahead by learning VBA The difference between programming errors and runtime errorsTips for finding and fixing bugsHow to customize Excel's user interfaceWays to super-charge your formulas with custom worksheet functionsVBA dos and don'ts

Table of contents

Introduction 1 Part I: Getting Started with Excel VBA Programming 9 Chapter 1: What Is VBA? 11 Chapter 2: Jumping Right In 21 Part II: How VBA Works with Excel 31 Chapter 3: Working in the Visual Basic Editor 33 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 115 Chapter 9: Using VBA and Worksheet Functions 129 Chapter 10: Controlling Program Flow and Making Decisions 143 Chapter 11: Automatic Procedures and Events 163 Chapter 12: Error-Handling Techniques 183 Chapter 13: Bug Extermination Techniques 197 Chapter 14: VBA Programming Examples 209 Part IV: Communicating with Your Users 231 Chapter 15: Simple Dialog Boxes 233 Chapter 16: UserForm Basics 249 Chapter 17: Using UserForm Controls 265 Chapter 18: UserForm Techniques and Tricks 283 Chapter 19: Accessing Your Macros through the User Interface 307 Part V: Putting It All Together 327 Chapter 20: Creating Worksheet Functions -- and Living to Tell about It 329 Chapter 21: Creating Excel Add-Ins 347 Part VI: The Part of Tens 359 Chapter 22: Ten VBA Questions (and Answers) 361 Chapter 23: (Almost) Ten Excel Resources 365 Chapter 24: Ten VBA Do's and Don'ts 369 Index 375