Excel VBA programming for dummies

by John Walkenbach

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.

MoreLess

Alternative title:	Microsoft Excel VBA programming for dummies
Year of publication:	2013 ; 3rd ed (Online-Ausg.)
Authors:	Walkenbach, John
Publisher:	Hoboken, N.J : Wiley
Subject:	Finanzmathematik \| Mathematical finance \| Software \| Mathematische Optimierung \| Mathematical programming
Description of contents:	Description [swbplus.bsz-bw.de]

Online Resource

Check full text access |

More access options

site.ebrary.com

ebookcentral.proquest.com

Check Google Scholar

In libraries world-wide (WorldCat)

In German libraries (KVK)

subito order

I need help

Extent:	Online-Ressource (xvi, 390 p.) ill.
Series:	--For dummies
Type of publication:	Book / Working Paper
Language:	English
Notes:	Includes index. - Electronic reproduction; Palo Alto, Calif; ebrary; 2013; Available via World Wide Web; Access may be limited to ebrary affiliated libraries Excel® VBA Programming For Dummies®, 3rd Edition; Contents at a Glance; Table of Contents; Introduction; Is This the Right Book?; So You Want to Be a Programmer. . . .; Why Bother?; What I Assume about You; Obligatory TypographicalConventions Section; Check Your Security Settings; How This Book Is Organized; Icons Used in This Book; Getting the Sample Files; Now What?; Part I: Getting Started with Excel VBA Programming; Chapter 1: What Is VBA?; Okay, So What Is VBA?; What Can You Do with VBA?; Advantages and Disadvantages of VBA; VBA in a Nutshell; An Excursion into Versions Chapter 2: Jumping Right InFirst Things First; What You'll Be Doing; Taking the First Steps; Recording the Macro; Testing the Macro; Examining the Macro; Modifying the Macro; Saving Workbooks That Contain Macros; Understanding Macro Security; More about the NameAndTime Macro; Part II: How VBA Works with Excel; Chapter 3: Working in the Visual Basic Editor; What Is the Visual Basic Editor?; Working with the Project Window; Working with a Code Window; Customizing the VBA Environment; Chapter 4: Introducing the Excel Object Model; Excel Is an Object?; Climbing the Object Hierarchy Wrapping Your Mind around CollectionsReferring to Objects; Diving into Object Properties and Methods; Finding Out More; Chapter 5: VBA Sub and Function Procedures; Subs versus Functions; Executing Sub procedures; Executing Function procedures; Chapter 6: Using the Excel Macro Recorder; Is It Live, or Is It VBA?; Recording Basics; Preparing to Record; Relative or Absolute?; What Gets Recorded?; Recording Options; Is This Thing Efficient?; Part III: Programming Concepts; Chapter 7: Essential VBA Language Elements; Using Comments in Your VBA Code; Using Variables, Constants, and Data Types Using Assignment StatementsWorking with Arrays; Using Labels; Chapter 8: Working with Range Objects; A Quick Review; Other Ways to Refer to a Range; Some Useful Range Object Properties; Some Useful Range Object Methods; Chapter 9: Using VBA and Worksheet Functions; What Is a Function?; Using Built-In VBA Functions; Using Worksheet Functions in VBA; Using Custom Functions; Chapter 10: Controlling Program Flow and Making Decisions; Going with the Flow, Dude; The GoTo Statement; Decisions, Decisions; Knocking Your Code for a Loop; Using For Each-Next Loops With Collections Chapter 11: Automatic Procedures and EventsPreparing for the Big Event; Where Does the VBA Code Go?; Writing an Event-Handler Procedure; Introductory Examples; Examples of Activation Events; Other Worksheet-Related Events; Events Not Associated with Objects; Chapter 12: Error-Handling Techniques; Types of Errors; An Erroneous Example; Handling Errors Another Way; Handling Errors: The Details; An Intentional Error; Chapter 13: Bug Extermination Techniques; Species of Bugs; Identifying Bugs; Debugging Techniques; About the Debugger; Bug Reduction Tips; Chapter 14: VBA Programming Examples Working with Ranges pt. 1. Getting started with Excel VBA programming -- pt. 2. How VBA works with Excel -- pt. 3. Programming concepts -- pt. 4. Communicating with your users -- pt. 5. Putting it all together -- pt. 6. The part of tens Microsoft Excel VBA programming for dummies
ISBN:	978-1-118-49174-4 ; 978-1-118-49037-2 ; 978-1-118-49037-2
Source:	ECONIS - Online Catalogue of the ZBW

Persistent link: https://www.econbiz.de/10012683382