Description |
1 online resource (419 pages) |
Series |
For dummies |
|
--For dummies.
|
Contents |
Intro; Title Page; Copyright Page; Table of Contents; Introduction; About This Book; Obligatory Typographical Conventions Section; Check Your Security Settings; Foolish Assumptions; Icons Used in This Book; Sample Files Online; Where to Go from Here; Part 1 Getting Started with Excel VBA Programming; Chapter 1 What Is VBA?; Okay, So What Is VBA?; What Can You Do with VBA?; Inserting a bunch of text; Automating a task you perform frequently; Automating repetitive operations; Creating a custom command; Creating a custom button; Developing new worksheet functions |
|
Creating custom add-ins for ExcelAdvantages and Disadvantages of VBA; VBA advantages; VBA disadvantages; VBA in a Nutshell; Excel Compatibility; Chapter 2 Jumping Right In; First 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; Revealing More about the NameAndTime Macro; Part 2 How VBA Works with Excel; Chapter 3 Working in the Visual Basic Editor; What Is the Visual Basic Editor?; Activating the VBE; Understanding VBE components |
|
Working with the Project WindowAdding a new VBA module; Removing a VBA module; Exporting and importing objects; Working with a Code Window; Minimizing and maximizing windows; Creating a module; Getting VBA code into a module; Entering code directly; Using the macro recorder; Copying VBA code; Customizing the VBA Environment; Using the Editor tab; Using the Editor Format tab; Using the General tab; Using the Docking tab; Chapter 4 Introducing the Excel Object Model; Excel Is an Object?; Climbing Down the Object Hierarchy; Wrapping Your Mind around Collections; Referring to Objects |
|
Navigating through the hierarchySimplifying object references; Diving into Object Properties and Methods; Object properties; Object methods; Object events; Finding Out More; Using VBA's Help system; Using the Object Browser; Automatically listing properties and methods; Chapter 5 VBA Sub and Function Procedures; Understanding Subs versus Functions; Looking at Sub procedures; Looking at Function procedures; Naming Subs and Functions; Executing Sub procedures; Executing the Sub procedure directly; Executing the procedure from the Macro dialog box; Executing a macro by using a shortcut key |
|
Executing the procedure from a button or shapeExecuting the procedure from another procedure; Executing Function procedures; Calling the function from a Sub procedure; Calling a function from a worksheet formula; Chapter 6 Using the Excel Macro Recorder; Recording Basics; Preparing to Record; Relative or Absolute?; Recording in absolute mode; Recording in relative mode; What Gets Recorded?; Recording Options; Macro name; Shortcut key; Store Macro In option; Description; Is This Thing Efficient?; Part 3 Programming Concepts; Chapter 7 Essential VBA Language Elements |
Summary |
To take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you'll find an overview of the essential elements and concepts for programming with Excel. In no time, you'll discover techniques for handling errors and exterminating bugs, working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, readers will be creating Excel applications custom fit to their unique needs! |
Notes |
Using Comments in Your VBA Code |
|
Print version record |
SUBJECT |
Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
|
Microsoft Excel (Computer file) fast (OCoLC)fst01366659 |
Subject |
Visual Basic for Applications (Computer program language)
|
|
Electronic spreadsheets.
|
|
Business -- Computer programs.
|
|
Business -- Computer programs.
|
|
Electronic spreadsheets.
|
|
Visual Basic for Applications (Computer program language)
|
Form |
Electronic book
|
Author |
Walkenbach, John
|
ISBN |
9781119518235 |
|
1119518237 |
|