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

Title Excel VBA : 24-hour trainer / Tom Urtis
Edition Second edition
Published Indianapolis, IN : Wrox, a Wiley brand, [2015]
Online access available from:
ProQuest Ebook Central (owned titles)    View Resource Record  


Description 1 online resource
Contents Cover; Title Page; Copyright; Contents; Part I: 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; Simplifying the Workbook's Look and Feel for Other Users; Controlling 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
Lesson RequirementsHints; Step-by-Step; Lesson 9: Making Decisions with VBA; Understanding Logical Operators; AND; OR; NOT; Choosing Between This or That; If ... Then; If ... Then ... Else; If ... Then ... ElseIf; IIF; Select Case; Getting Users to Make Decisions; Message Boxes; Input Boxes; Try It; Lesson Requirements; Hints; Step-by-Step; Part III: Beyond the Macro Recorder: Writing Your Own Code; Lesson 10: Repeating Actions with Loops; What Is a Loop?; Types of Loops; Do ... While; Do ... Until; Do ... Loop While; Do ... Loop Until; While ... Wend; Nesting Loops; Try It; Lesson Requirements; Hints; Step-by-Step
Step-by-StepPart II: Diving Deeper into VBA; Lesson 5: Object-Oriented Programming: An Overview; What "Object-Oriented Programming" Means; The Object Model; Properties; Methods; Collections; Try It; Lesson 6: Variables, Data Types, and Constants; What Is a Variable?; Assigning Values to Variables; Why You Need Variables; Data 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
The Macro Dialog BoxShortcut Key; Try It; Lesson Requirements; Hints; Step-by-Step; Lesson 3: Introducing the Visual Basic Editor; What Is the VBE?; How to Get Into the VBE; Understanding the VBE; Understanding Modules; Using the Object Browser; Exiting the VBE; Try 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; Hints
Try ItLesson Requirements; Step-by-Step; Lesson 7: Understanding Objects and Collections; Workbooks; Cells and Ranges; SpecialCells; Try It; Lesson Requirements; Step-by-Step; Lesson 8: Working with Ranges; Working with Contiguously Populated Ranges; Using the Cells Property; Using CurrentRegion; Working with Noncontiguously Populated Ranges; Using Range with Several Cells; Using OFFSET; Using RESIZE; Identifying a Data Range; Identifying the UsedRange; Finding the Dynamic Last Rows and Columns; Identifying Where the Range Starts and Ends When No Start or End Point Is Known; Try It
Summary Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined wit
Notes "Programmer to programmer"--Page [4] of cover
Includes index
Online resource; title from PDF title page (Ebsco, viewed March 16, 2015)
Subject Microsoft Excel (Computer file)
Visual Basic for Applications (Computer program language)
Business -- Computer programs.
Electronic spreadsheets.
Form Electronic book
ISBN 1118991400 (electronic bk)
1118991419 (electronic bk)
9781118991404 (electronic bk)
9781118991411 (electronic bk)
Other Titles Excel Visual Basic Applications : twenty-four hour trainer