Details

Excel VBA Programming For Dummies

6. Aufl.

von: Dick Kusleika
28,99 €
Verlag:	Wiley
Format:	PDF
Veröffentl.:	20.12.2021
ISBN/EAN:	9781119843085
Sprache:	englisch
Anzahl Seiten:	432

In den Warenkorb

Als Gutschein

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

Titelbeschreibung

Find out what Excel is capable of with this step-by-step guide to VBA Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software. Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to: <ul> <li>Understand the basic tools and operations of Visual Basic for Applications</li> <li>Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets</li> <li>Deal with errors and exceptions and eliminate the bugs in your code</li> </ul> Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language.

Inhaltsverzeichnis

Introduction 1 Part 1: Starting Excel VBA Programming 7 Chapter 1: Getting to Know VBA 9 Chapter 2: Building Simple Macros 17 Part 2: Employing VBA 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 67 Chapter 6: Using the Excel Macro Recorder 83 Part 3: Programming Concepts 97 Chapter 7: Essential VBA Language Elements 99 Chapter 8: Working with Range Objects 119 Chapter 9: Using VBA and Worksheet Functions 135 Chapter 10: Controlling Program Flow and Making Decisions 151 Chapter 11: Automatic Procedures and Events 171 Chapter 12: Error-Handling Techniques 193 Chapter 13: Bug Extermination Techniques 205 Chapter 14: VBA Programming Examples 219 Part 4: Communicating with Your Users 243 Chapter 15: Simple Dialog Boxes 245 Chapter 16: UserForm Basics 263 Chapter 17: Using UserForm Controls 281 Chapter 18: UserForm Techniques and Tricks 301 Chapter 19: Accessing Your Macros through the User Interface 329 Part 5: Putting It All Together 343 Chapter 20: Creating Worksheet Functions 345 Chapter 21: Creating Excel Add-Ins 365 Part 6: The Part of Tens 377 Chapter 22: Ten Handy Visual Basic Editor Tips 379 Chapter 23: Resources for VBA Help 389 Chapter 24: Ten VBA Do’s and Don’ts 395 Index 401

Autorenportrait

Dick Kusleika has over 25 years’ experience helping Office users get the most out of Microsoft’s bestselling software. From online forums to blogs, books, and conferences, he delivers sound and straightforward advice to readers of all skill levels.

Back cover copy

Unlock Excel’s full potential with VBA Besides changing the tires on your car, the Microsoft® Excel® application can do almost anything. And the possibilities are truly endless when you learn to program with Excel Visual Basic for Applications (VBA). With simple examples and step-by-step tutorials, Excel® VBA Programming For Dummies walks you through how to automate processes, write custom worksheet functions, and more. Whether you’re a VBA novice writing your first program or an Excel pro looking for the latest tips and tricks, this book is your key to unlocking everything Excel has to offer. Inside… <ul><li>Use the Visual Basic Editor</li> <li>Understand the Excel Object Model</li> <li>Record Excel macros</li> <li>Learn essential VBA elements</li> <li>Create worksheet functions</li> <li>Troubleshoot your code</li> <li>Write Excel Add-Ins</li> <li>Discover UserForm basics</li></ul>