book

Excel VBA 24-Hour Trainer, 2nd Edition

by Tom Urtis

March 2015

Intermediate to advanced

504 pages

11h 8m

English

Wrox

Read now

Unlock full access

Who This Book Is ForWhat This Book CoversHow This Book Is StructuredWhat You Need to Use This BookConventionsErratap2p.wrox.com
What is VBA?A Brief History of VBAWhat VBA Can Do for YouLiabilities of VBATry It
Composing Your First MacroRunning A MacroTry It
What is the VBE?Try It
Toolbars in the VBEMacros and ModulesUnderstanding the CodeEditing a Macro with Comments and Improvements to the CodeTry It
What “Object-Oriented Programming” MeansThe Object ModelTry It
What is a Variable?Assigning Values to VariablesWhy You Need VariablesData TypesForcing Variable DeclarationUnderstanding a Variable's ScopeTry It
WorkbooksCells and RangesTry It

Working with Contiguously Populated RangesWorking with Noncontiguously Populated RangesTry It
Understanding Logical OperatorsChoosing between this or thatGetting Users to Make DecisionsTry It
What is a Loop?Nesting LoopsTry It
Understanding A1 and R1C1 ReferencesProgramming Your Formula Solutions with VBATry It
What is an Array?The Option Base StatementBoundaries in ArraysDeclaring Arrays with Fixed ElementsDeclaring Dynamic Arrays with Redim and PreserveTry It
What Is an Event?Worksheet Events: An OverviewExamples of Common Worksheet EventsTry It
Workbook Events: An OverviewExamples of Common Workbook EventsTry It
Deleting Rows Containing Duplicate EntriesWorking with Duplicate DataTry It
Working with Form Controls and ActiveX ControlsTry It
Adding a Chart to a Chart SheetAdding an Embedded Chart to a WorksheetMoving a ChartLooping Through All Embedded ChartsTry It
Creating a PivotTable ReportUnderstanding PivotCachesManipulating PivotFields in VBAManipulating PivotItems with VBACreating a PivotTables CollectionTry It
What Is a User-Defined Function?UDF Examples That Solve Common TasksVolatile FunctionsTry It
What Is Debugging?What Causes Errors?Weapons of Mass DebuggingTrapping ErrorsTry It
What Is a UserForm?Creating a UserFormDesigning a UserFormAdding Controls to a UserFormShowing a UserFormWhere Does the UserForm's Code Go?Closing a UserFormTry It
Understanding the Frequently Used UserForm ControlsTry It
The UserForm ToolbarModal versus ModelessDisabling the UserForm's Close ButtonMaximizing Your UserForm's SizeSelecting and Displaying Photographs on a UserFormUnloading a UserForm AutomaticallyPre-sorting the ListBox and ComboBox ItemsPopulating ListBoxes and ComboBoxes with Unique ItemsDisplaying a Real-Time Chart in a UserFormTry It
What Is a Class?What Is a Class Module?Creating Your Own ObjectsAn Important Benefit of Class ModulesCreating CollectionsClass Modules for Embedded ObjectsTry It
What Is an Excel Add-In?Creating an Add-InConverting a File to an Add-InInstalling an Add-InCreating a User Interface for Your Add-InClosing Add-InsRemoving an Add-In from the Add-Ins ListTry It
Creating QueryTables from Web QueriesCreating a QueryTable for AccessUsing Text Files to Store External DataTry It
Introducing ADOAn Introduction to Structured Query Language (SQL)Try It
Selecting Cells and RangesFiltering DatesSetting Page Breaks for Specified AreasUsing a Comment to Log Changes in a CellUsing the Windows API with VBAScheduling Your Workbook for SuicideTry It
Why Automate Another Application?Understanding Office AutomationTry It
Activating a Word DocumentCreating a New Word DocumentCopying an Excel Range to a Word DocumentPrinting a Word Document from ExcelImporting a Word Document to ExcelTry It
Opening OutlookComposing an E-mail in Outlook from ExcelPutting It All TogetherE-mailing a Single WorksheetTry It
Adding a Record to an Access TableExporting an Access Table to an Excel SpreadsheetCreating a New Table in AccessTry It
Creating a New PowerPoint PresentationCopying a Worksheet Range to a PowerPoint SlideCopying Chart Sheets to PowerPoint SlidesRunning a PowerPoint Presentation from ExcelTry It

Overview

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 with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios.

This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice.

Program Excel's newest chart and pivot table object models

Manipulate the user interface to customize the look and feel of a project

Utilize message boxes, input boxes, and loops to yield customized logical results

Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel

If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need.