Cantitate/Preț
Produs

Excel VBA Programming For Dummies

De (autor)
Notă GoodReads:
en Limba Engleză Carte Paperback – 27 Oct 2015

Learn to:

  • Use the essential tools and operations for VBA
  • Get the most out of Excel′s macro recording feature
  • Handle errors and eliminate bugs in your code
  • Develop custom worksheet functions and user–oriented applications

Learn VBA and unlock Excel′s full performance potential
Excel is essential in the business world, and knowing how to use its programming language can make you more productive and increasingly valuable to a company. This accessible guide explains how to use Excel VBA to open up Excel′s expansive capabilities. You′ll learn basic programming concepts and how to create custom functions, add–ins, and applications with VBA.

  • What it′s all about start with a complete overview of VBA and learn how it can help you automate routine tasks, create custom commands and add–ins, and develop macro–driven applications
  • A world of objects dig into the Excel object model and see how VBA is implemented in Excel
  • Master basic programming concepts learn the lingo and find out what programming involves
  • Dive a little deeper explore range objects and their properties and create a variety of alternatives to Excel UserForms
  • Get down to business discover how to create custom dialog boxes, customize the Ribbon, and add a button to the Quick Access Toolbar
  • Put it all to work include your own custom buttons in the Excel user interface, design user–oriented applications, and work with other Office applications

Open the book and find:

  • Advantages and disadvantages of VBA
  • How the Excel object hierarchy works
  • Step–by–step instructions for creating macros
  • Useful Range object properties and methods
  • Techniques for handling errors
  • How to develop custom solutions to fit your needs
  • Tips for exterminating bugs in your code
Citește tot Restrânge

Preț: 10850 lei

Preț vechi: 13562 lei
-20%

Puncte Express: 163

Preț estimativ în valută:
2222 2535$ 1995£

Carte disponibilă

Livrare economică 28 decembrie 18 - 09 ianuarie 19
Livrare express 14-18 decembrie pentru 2474 lei

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781119077398
ISBN-10: 1119077397
Pagini: 408
Ilustrații: illustrations
Dimensiuni: 187 x 234 x 21 mm
Greutate: 0.50 kg
Ediția: 4th Edition
Editura: Wiley
Locul publicării: Hoboken, United States

Public țintă

Targeting beginning VBA programmers and beginning to intermediate Excel users, Excel VBA Programming For Dummies is an excellent resource for getting up to speed in the creation of customized solutions with Excel applications. With VBA, Excel users add a whole new dimension to their ability to make Excel work for them. 

Textul de pe ultima copertă

Learn to:

  • Use the essential tools and operations for VBA
  • Get the most out of Excel′s macro recording feature
  • Handle errors and eliminate bugs in your code
  • Develop custom worksheet functions and user–oriented applications

Learn VBA and unlock Excel′s full performance potential
Excel is essential in the business world, and knowing how to use its programming language can make you more productive and increasingly valuable to a company. This accessible guide explains how to use Excel VBA to open up Excel′s expansive capabilities. You′ll learn basic programming concepts and how to create custom functions, add–ins, and applications with VBA.

  • What it′s all about start with a complete overview of VBA and learn how it can help you automate routine tasks, create custom commands and add–ins, and develop macro–driven applications
  • A world of objects dig into the Excel object model and see how VBA is implemented in Excel
  • Master basic programming concepts learn the lingo and find out what programming involves
  • Dive a little deeper explore range objects and their properties and create a variety of alternatives to Excel UserForms
  • Get down to business discover how to create custom dialog boxes, customize the Ribbon, and add a button to the Quick Access Toolbar
  • Put it all to work include your own custom buttons in the Excel user interface, design user–oriented applications, and work with other Office applications

Open the book and find:

  • Advantages and disadvantages of VBA
  • How the Excel object hierarchy works
  • Step–by–step instructions for creating macros
  • Useful Range object properties and methods
  • Techniques for handling errors
  • How to develop custom solutions to fit your needs
  • Tips for exterminating bugs in your code

Cuprins

Introduction 1
Part I: Getting Started with Excel VBA Programming 7
Chapter 1: What Is VBA? 9
Chapter 2: Jumping Right In 19
Part II: How VBA Works with Excel 29
Chapter 3: Working in the Visual Basic Editor 31
Chapter 4: Introducing the Excel Object Model 51
Chapter 5: VBA Sub and Function Procedures 65
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 131
Chapter 10: Controlling Program Flow and Making Decisions 145
Chapter 11: Automatic Procedures and Events 165
Chapter 12: Error Handling Techniques 187
Chapter 13: Bug Extermination Techniques 201
Chapter 14: VBA Programming Examples 215
Part IV: Communicating with Your Users 237
Chapter 15: Simple Dialog Boxes 239
Chapter 16: UserForm Basics 257
Chapter 17: Using UserForm Controls 275
Chapter 18: UserForm Techniques and Tricks 295
Chapter 19: Accessing Your Macros through the User Interface 321
Part V: Putting It All Together 333
Chapter 20: Creating Worksheet Functions and Living to Tell about It 335
Chapter 21: Creating Excel Add–Ins 353
Part VI: The Part of Tens 365
Chapter 22: Ten VBA Questions (and Answers) 367
Chapter 23: (Almost) Ten Excel Resources 371
Chapter 24: Ten VBA Do s and Don ts 375
Index 381


Notă biografică

John Walkenbach is a leading authority on spreadsheet software and creator of the award–winning Power Utility Pak. The author of more than 50 books, he has also written articles and reviews for PC World, InfoWorld, and Windows. John maintains the popular Spreadsheet Page at http://spreadsheetpage.com.