Excel VBA – Course Contents

Excel VBA - Introduction

Getting Started

The Visual Basic Development Environment

Watch a Macro Being Recorded

Excel Dot Notation

Methods

The Range Property

The Worksheets Object

The VBA Developer Toolbar

The ActiveCell

Offset

The Resize Property

VBA Programming Variables

Variable Names

Variables - Practice

Using variables to add, multiply, divide, and subtract

Subtraction

Multiplication

Division

Other Numerical Variable Types

Variable Types and Text

Conditional Logic

Else

ElseIf

Conditional Operators

Logical Operators

Boolean Values

Logical Not

Logical And

Logical Or

Nested If

VBA Practice 1

ActiveCell Referencing

Changing the Background Colour of a Cell

Cell Content Alignment

VBA Practice 2

Select Case

VBA Practice 3

With ... End With

Working with Strings of Text in Excel VBA

Changing Case

Trim and Len

Space

Replace

StrReverse

InStr, InStrRev

Left, Right

Mid

Programming Loops in Excel VBA

For Loops

The Cells Property

The For Each Loop

The Do While Loop

Do Until Loop

Excel VBA and Arrays

Arrays and Loops

Multidimensional Arrays

Arrays and the Split function

Join

Subs and Functions

Subroutines

Passing Values to a Sub

Exit Sub

The Message Box

Functions

Using Excel's own WorkSheet Function in VBA

The Set Keyword in Excel VBA

VBA and Text Files

Writing to a text file

User Forms

Adding Controls to a User Form

Adding Code to a User Form Button

Add a Button to the Excel Ribbon

Launch a Form from a Button on a Spreadsheet

Launch a Form from the Excel Task Bar in Excel 2007

Adding New Tabs to the Excel Ribbon (versions 2010 and later)

Adding Tabs to the Excel Ribbon

An Excel Picture Viewer

Spreadsheet Image Information

Designing the User Form

Adding Labels to a Form

Adding Textboxes to a Form

Adding Option Buttons to a Form

Adding Command buttons to a Form

The Add New Photo Tab

Add an Open File Dialogue Box to a Form

The Form Initialize Event

Loading Image Information

Load Image Information

Get the Data for the Textboxes

Option Buttons

Load an Image into an Image Box

The Next Photo button

The Previous Photo Button

The Add New Photo tab

64 Bit Open File Dialogue Box

Get the Image Name

The Save New Details button

TextBox Error Check

ComboBox Error Check

Option Button Error Checking

Transferring Data to a Spreadsheet

Copy an Image to a Folder

Excel VBA Charts

Excel VBA and Embedded Charts

Formatting the Chart

Deleting Charts

Adding Charts to an Excel VBA User Form

Loading the Combo Box

Excel Chart Images

A TreeView Project

Design the User Form

Adding Nodes to a TreeView

Parent Nodes

Child Nodes

The Node Click Event

Appendix - Chart Type Constants

Column Charts

Bar Charts

Line Charts

Pie Charts

XY Scatter Chart Constants

Area Charts and Other Chart Constants