Excel 2013/2016 Programming with VBA

Price
$885.00
Duration
 3 Days
Delivery Methods
 VILT    Private Group

 

Upcoming Class Dates and Times

Jan 27  - Jan 29, 2021
8:00AM - 4:00PM Central
3 Days
Virtual Instructor Led
 GTR
Mar 08  - Mar 10, 2021
8:00AM - 4:00PM Central
3 Days
Virtual Instructor Led
 GTR
Apr 20  - Apr 22, 2021
8:00AM - 4:00PM Central
3 Days
Virtual Instructor Led
 GTR
Jun 07  - Jun 09, 2021
8:00AM - 4:00PM Central
3 Days
Virtual Instructor Led
 GTR

Agenda

1 - GETTING STARTED
  • Introducing Visual Basic for Applications
  • Displaying the Developer Tab in the Ribbon
  • Recording a Macro
  • Saving a Macro-Enabled Workbook
  • Running a Macro
  • Editing a Macro in the Visual Basic Editor
  • Understanding the Development Environment
  • Using Visual Basic Help
  • Closing the Visual Basic Editor
  • Understanding Macro Security
2 - WORKING WITH PROCEDURES AND FUNCTIONS
  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures
  • Using the Immediate Window to Call Procedures
  • Creating a Function Procedure
  • Naming Procedures
  • Working with the Code Editor
3 - UNDERSTANDING OBJECTS
  • Understanding Objects
  • Navigating the Excel Object Hierarchy
  • Understanding Collections
  • Using the Object Browser
  • Working with Properties
  • Using the With Statement
  • Working with Methods
  • Creating an Event Procedure
4 - USING EXPRESSIONS, VARIABLES, AND INTRINSIC FUNCTIONS
  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Using Intrinsic Functions
  • Understanding Constants
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes
  • Declaring and Using Object Variables
5 - CONTROLLING PROGRAM EXECUTION
  • Understanding Control-of-Flow Structures
  • Working with Boolean Expressions
  • Using the If...End If Decision Structures
  • Using the Select Case...End Select Structure
  • Using the Do...Loop Structure
  • Using the For...To...Next Structure
  • Using the For Each...Next Structure
  • Guidelines for use of Control-of-Flow Structures
6 - WORKING WITH FORMS AND CONTROLS
  • Understanding UserForms
  • Using the Toolbox
  • Working with UserForm Properties, Events, and Methods
  • Understanding Controls
  • Setting Control Properties in the Properties Window
  • Working with the Label Control
  • Working with the Text Box Control
  • Working with the Command Button Control
  • Working with the Combo Box Control
  • Working with the Frame Control
  • Working with Option Button Controls
  • Working with Control Appearance
  • Setting the Tab Order
  • Populating a Control
  • Adding Code to Controls
  • Launching a Form in Code
7 - WORKING WITH THE PIVOTTABLE OBJECT
  • Understanding PivotTables
  • Creating a PivotTable Using Worksheet Data
  • Working with the PivotTable Objects
  • Working with the PivotFields Collection
  • Assigning a Macro to the Quick Access Toolbar
8 - DEBUGGING CODE
  • Understanding Errors
  • Using Debugging Tools
  • Setting Breakpoints
  • Stepping through Code
  • Using Break Mode during Run mode
  • Determining the Value of Expressions
9 - HANDLING ERRORS
  • Understanding Error Handling
  • Understanding VBA's Error Trapping Options
  • Trapping Errors with the On Error Statement
  • Understanding the Err Object
  • Writing an Error-Handling Routine
  • Working with Inline Error Handling