Limit search to available items
Book Cover
Author Urtis, Tom.

Title Excel VBA : 24-hour trainer / Tom Urtis
Published Indianapolis, Ind. : Wiley Publishing, [2011]
Online access available from:
Safari O'Reilly books online    View Resource Record  


Description 1 online resource (xxxi, 395 pages) : illustrations
Contents Excel VBA; About the Author; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Instructional Videos on DVD; Conventions; Supporting Websites and Code; Errata;; Section 1: Understanding the BASICs; Lesson 1: Introducing VBA; What Is VBA?; A Brief History of VBA; What VBA Can Do for You; Automating a Recurring Task; Automating a Repetitive Task; Running a Macro Automatically if Another Action Takes Place; Creating Your Own Worksheet Functions
Exiting the VBETry It; Lesson 4: Working in the VBE; Toolbars in the VBE; Macros and Modules; Locating Your Macros; Understanding the Code; Editing a Macro with Comments and Improvements to the Code; Deleting a Macro; Inserting a Module; Renaming a Module; Deleting a Module; Locking and Protecting the VBE; Try It; Lesson Requirements; Step-by-Step; Section 2: Diving Deeper into VBA; Lesson 5: Object-oriented; What "Object-Oriented Programming" Means; The Object Model; Properties; Methods; Collections; Try It; Lesson 6: Variables, Data Types, ; What Is a Variable?; Assigning Values to Variables
Simplifying the Workbook's Look and Feel for Other UsersControlling Other Office Applications from Excel; Liabilities of VBA; Try It; Lesson 2: Getting Started with Macros; Composing Your First Macro; Accessing the VBA Environment; Using the Macro Recorder; Running a Macro; The Macro Dialog Box; Shortcut Key; Try It; Lesson Requirements; Step-by-Step; Lesson 3: Introducing the; What Is the VBE?; How To Get Into the VBE; Understanding the VBE; The Project Explorer Window; The Code Window; The Properties Window; The Immediate Window; Understanding Modules; Using the Object Browser
Understanding Logical OperatorsAND; OR; NOT; Choosing Between This or That; If ... Then; If ... Then ... Else; If ... Then ... ElseIf; Select Case; Getting Users to Make Decisions; Message Boxes; Input Boxes; Try It; Lesson Requirements; Step-by-Step; Section 3: Beyond the Macro Recorder: Writing Your Own Code; Lesson 9: Repeating Actions with Loops; What Is a Loop?; Types of Loops; For ... Next; For ... Each ... Next; Exiting a For ... Loop; Looping In Reverse with Step; Do ... While; Do ... Until; Do ... Loop ... While; Do ... Loop ... Until; While ... Wend; Nesting Loops; Try It; Lesson Requirements; Step-by-Step; Lesson 10: Working with Arrays
Why You Need VariablesData Types; Understanding the Different Data Types; Declaring a Variable for Dates and Times; Declaring a Variable with the Proper Data Type; Forcing Variable Declaration; Understanding a Variable's Scope; Local Macro Level Only; Module Level; Application Level; Constants; Choosing the Scope and Lifetime of Your Constants; Try It; Lesson Requirements; Step-by-Step; Lesson 7: Understanding Objects and Collections; Workbooks; Worksheets; Cells and Ranges; SpecialCells; Try It; Lesson Requirements; Step-by-Step; Lesson 8: Making Decisions with VBA
Summary Increase your productivity and save time and effort with Excel VBA This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You'll learn how to use VBA to manipulate Excel in ways you may never
Notes "Wrox programmer to programmer"--Cover
Includes index
Print version record
Subject Microsoft Excel (Computer file)
Visual Basic for Applications (Computer program language)
Business -- Computer programs.
Electronic spreadsheets.
Form Electronic book
ISBN 047089069X
1118087607 (electronic bk.)
111808764X (electronic bk.)
9781118087602 (electronic bk.)
9781118087640 (electronic bk.)