Microsoft Excel VBA – Programming (2013, 2016)

Macros

• Record a Simple Macro
• Record a Macro
• Run a Macro

Understand the VB Editor

• Use the Menu Bar
• Use the Standard Toolbar
• Use the Project Explorer
• Use the Properties Window
• Understand the Code Window
• Understand Code Window Options
• Edit Code

Get Help

• Use .CHM or .HLP Files
• Close the Visual Basic Editor

Work with Objects

• Understand the Object Browser
• Understand Objects
• Understand the Objects Hierarchy
• Reference Objects

Understand Collections

• Use the Editing Features
• Use the Immediate Window
• Use the Auto List
• Use Auto Quick Info

Work with Variables

• Understand Variables
• Declare Variables
• Understand Data Types
• Store Values in Variables
• Store Objects in Variables

Create Procedures and Functions

• Understand Procedures
• Use the Macro Recorder to Create Sub Procedures
• Call Procedures from Procedures
• Use Intrinsic Functions
• Use Message Boxes
• Use Input Boxes

Create Functions

• Pass Arguments to a Function
• Work with Conditional Statements
• Understand Conditional Statements
• Work with Decision Structures
• Work with Loop Structures

Work with Forms and Controls

• Understand UserForms
• Use the Toolbox
• Work with UserForm Properties
• Events and Methods
• Use the Properties Window
• Understand Controls
• Work with the Label Control
• Work with the Text Box Control
• Work with the Command Button Control
• Work with the Combo Box Control
• Work with the Frame Control
• Work with the Option Button Controls

Add Functionality to Forms

• Work with Control Appearance
• Set the Tab Order
• Populate a Control
• Add Code to Controls
• Launch Forms from Procedures

Use Pivot Tables

• Understand Pivot Tables
• Create Pivot Tables
• Pivot Table Arguments
• Add Fields to Pivot Tables

Control Forms

• Control Pivot Tables from a Form
• Control a Form from a Custom Toolbar

Understand Debugging

• Understand Errors
• Debug Code
• Debug Tools
• Use the Locals Window
• Use the Watch Window
• Use Breakpoints