Advanced UserForm List Boxes

Displaying Unique Items

Using a Variable Range Source

List Boxes with Changing Contents

Multiple Column List Boxes

List Boxes to Select Rows/Columns/Sheets

Creating Wizards

Using Multiple UserForms

Using 1 UserForm and MultiPage Control

Advanced UserForms

Modeless Dialog Boxes

Using Labels to Display Formula Results

Examining a Text Utility

Seeing how Dialog Box can be made that will:

  Change text case

  Add text

  Remove Text

  Remove Spaces

Advanced Excel Events

Change, SelectionChange)

Specify Range to Monitor for Change

Application Events

Timed Events

Disabling events

Working with Charts

Activating & Deleting

Chart Formatting

Converting Embedded Chart to Chart Sheet and Vice-Versa

Looping Through All Charts

Changing Chart Type Based on Selected Cell

Displaying in UserForms

Working with Pivot Tables

Creating a Pivot Table with VBA

Modifying a Pivot Table

Creating Multiple Pivot Tables

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

Working with Other Applications

Running Simple Applications – Character Map, Calculator

Interacting with Microsoft Word

Developing an Add-In

Testing Your Application

Protecting Your Add-In

Snooping Around a Protected Add-In

May 27/28/29