Excel 2013/2016 Programming with VBA

Instructor-Led 9 Agenda

Description

View Course Outline

Working with Forms and Controls Lesson Id 6

Working with Forms and Controls

Working with the PivotTable Object Lesson Id 7

Working with the PivotTable Object

Debugging Code Lesson Id 8

Debugging Code

Handling Errors Lesson Id 9

Handling Errors

Getting Started Lesson Id 1

Getting Started

Working with Procedures and Functions Lesson Id 2

Working with Procedures and Functions

Understanding Objects Lesson Id 3

Understanding Objects

Using Expressions, Variables, and Intrinsic Functions Lesson Id 4

Using Expressions, Variables, and Intrinsic Functions

Controlling Program Execution Lesson Id 5

Controlling Program Execution

Lesson Id	Title	Description
6	Working with Forms and Controls	Understanding UserForms<br />Using the Toolbox<br />Working with UserForm Properties, Events, and Methods<br />Understanding Controls<br />Setting Control Properties in the Properties Window<br />Working with the Label Control<br />Working with the Text Box Control<br />Working with the Command Button Control<br />Working with the Combo Box Control<br />Working with the Frame Control<br />Working with Option Button Controls<br />Working with Control Appearance<br />Setting the Tab Order<br />Populating a Control<br />Adding Code to Controls<br />Launching a Form in Code
7	Working with the PivotTable Object	Understanding PivotTables<br />Creating a PivotTable Using Worksheet Data<br />Working with the PivotTable Objects<br />Working with the PivotFields Collection<br />Assigning a Macro to the Quick Access Toolbar
8	Debugging Code	Understanding Errors<br />Using Debugging Tools<br />Setting Breakpoints<br />Stepping through Code<br />Using Break Mode during Run mode<br />Determining the Value of Expressions
9	Handling Errors	Understanding Error Handling<br />Understanding VBA's Error Trapping Options<br />Trapping Errors with the On Error Statement<br />Understanding the Err Object<br />Writing an Error-Handling Routine<br />Working with Inline Error Handling
1	Getting Started	Introducing Visual Basic for Applications<br />Displaying the Developer Tab in the Ribbon<br />Recording a Macro<br />Saving a Macro-Enabled Workbook<br />Running a Macro<br />Editing a Macro in the Visual Basic Editor<br />Understanding the Development Environment<br />Using Visual Basic Help<br />Closing the Visual Basic Editor<br />Understanding Macro Security
2	Working with Procedures and Functions	Understanding Modules<br />Creating a Standard Module<br />Understanding Procedures<br />Creating a Sub Procedure<br />Calling Procedures<br />Using the Immediate Window to Call Procedures<br />Creating a Function Procedure<br />Naming Procedures<br />Working with the Code Editor
3	Understanding Objects	Understanding Objects<br />Navigating the Excel Object Hierarchy<br />Understanding Collections<br />Using the Object Browser<br />Working with Properties<br />Using the With Statement<br />Working with Methods<br />Creating an Event Procedure
4	Using Expressions, Variables, and Intrinsic Functions	Understanding Expressions and Statements<br />Declaring Variables<br />Understanding Data Types<br />Working with Variable Scope<br />Using Intrinsic Functions<br />Understanding Constants<br />Using Intrinsic Constants<br />Using Message Boxes<br />Using Input Boxes<br />Declaring and Using Object Variables
5	Controlling Program Execution	Understanding Control-of-Flow Structures<br />Working with Boolean Expressions<br />Using the If...End If Decision Structures<br />Using the Select Case...End Select Structure<br />Using the Do...Loop Structure<br />Using the For...To...Next Structure<br />Using the For Each...Next Structure<br />Guidelines for use of Control-of-Flow Structures