Excel 2013 VBA

Programming in Microsoft

Excel VBA Terminology

Displaying the DEVELOPER Tab

The VBA Editor Screen

Opening and Closing the Editor

Understanding Objects

Viewing the Excel Object Model

Using the Immediate Window

Working With Object Collections

Setting Property Values

Working With Worksheets

Using the Object Browser

Programming With the Object Browser

Accessing Help

Code Glossary

Using the Project Explorer

Working With the Properties Window

Using the Work Area

Viewing Other Panes

Working With Toolbars

Working With a Code Module

Running Code From the Editor

Setting Breakpoints in Code

Stepping Through Code

Understanding Procedures

Where Procedures Live

Creating a New Sub Routine

Making Sense of IntelliSense

Using the Edit Toolbar

Commenting statements

Indenting Code

Bookmarking in Procedures

Understanding Variables

Creating and Using Variables

Implicit and Explicit Declarations

The Scope of Variables

Procedure Level Scoping

Module Level Scoping

Passing Variables by Reference

Passing Variables by Value

Data Types

Declaring Data types

Using Arrays

Understanding Functions

Creating VBA Functions

Using a VBA Function in a Worksheet

Setting Function Data Types

Using Multiple Arguments

Modifying a VBA Function

Creating a Function Library

Referencing a Function Library

Importing a VBA Module

Using a Function In VBA Code

The Application Object

The Workbook Objects

Program Testing with The Editor

Using Workbook Objects

The Worksheets Object

Using the Worksheets Object

The Range Object

Using Range Objects

Using Objects in a Procedure

The MsgBox Function

Using MsgBox

InputBox Techniques

Using the InputBox Function

Using the InputBox Method

The IF Statement

Using IF for Single Conditions

Using IF for multiple Conditions

The Select Case Statement

Using The Select Case Statement

For Loops

Looping With specified Iterations

The Do...Loop Statement

Looping With Unknown Iterations

About Custom Forms

Creating a Custom Form

Adding Text Boxes to a Form

Changing Text Box Control Properties

Adding Label Controls to a Form

Adding a Combo Box Control

Adding Option Buttons

Adding Command Buttons

Running a Custom Form

Handling Form Events

Initializing a Form

Closing a Form

Transferring Data From a Form

Running Form Procedures

Creating Error Checking Procedures

Running a Form From a Procedure

Running a Form from the Toolbar

Programming Automatic Procedures

Running Automatic Procedures

Automatically Starting a Workbook

Error types

The On Error statement

Creating a Simple Error Handler

Using the Resume Statement

Using Decision Structures in Error Handlers

Using the Err object

Error Handling in Event Procedures

Defining Custom Errors