Custom Functions

Why Create Functions

Create And Edit Functions

Declaring Functions

Arguments In Functions

Adding To Paste Function Dialog Box

Public Vs Private Declarations

Function Declarations

Procedure Declarations

Arrays

Introduction To Array Concept

Array Functions In Excel

Using Arrays In VBA

Working With Ranges

Move And Copy Fixed Or Indefinite Ranges

Determining Next Empty Cell

Determining Types Of Ranges

Returning Information About A Range

Analyzing Cells In A Range

Determining If A Range Is Contained In Another Range

Ranges And Arrays

Sorting An Array

Procedure To Sort

Worksheets

Working With Files

Processing A Series Of Files

Extracting File Information–Name,Path, etc.

Using Relative Sheet References In Custom Functions

Select Case

Using Case Instead of IF

Select Case Constructs

Creating and Designing Forms and Custom Dialog Boxes

VBA Forms vs. Excel Forms

Create a Custom Dialog Box form

Combo Boxes

List Boxes

Check Boxes

Option Buttons

Labels

Using Event Handling to Display Forms

User Form Templates

Multi – Page Forms