Custom Functions

Why Create Functions

Create And Edit Functions

Declaring Functions

Arguments In Functions

Adding To Paste Function Dialog Box

Public Vs Private Declarations

Extending the Scope of a Variable

Arrays

Introduction To Array Concept

Array Functions In Excel

Ranges And Arrays

Sorting An Array

Using Arrays In VBA to Sort Sheets Alphabetically

Working With Ranges

Move And Copy Fixed Or Variable Ranges

Determining Next Empty Cell

Determining Types Of Ranges

Copying Ranges from Sheet to Sheet, File to File

Returning Information About A Range

Analyzing Cells In A Range

Removing Empty Rows

Removing Rows based on Content

Determining If A Range Is Contained In Another Range

Procedure To Sort

Worksheets

Working With Files

Processing A Series Of Files

Extracting File Information–Name,Path, etc.

Using VBA to Process Text Files

Using VBA to Delete Files

Select Case

Using Case Instead of IF

Select Case Constructs

Nesting Case Statements

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