Objects

Methods

Properties

Programming Tools

The Menu Bar

Using the Project Explorer

Excel Constants

Variable Constants

Objects, Properties and Methods

Getting & Setting Properties

Calling Methods

Passing Arguments

Singular Objects & Collections of Objects

InputBox Function

MsgBox Function

Using a Set Statement

If Then Decision Structures

Logical Operators

Select Case Decision Structures

Case Else

Comparison Operators with Select Case Structure

For Loops

Do Loops

While...Wend Statement

Run mode and Design mode

Running Code from the development environment

Running Code from the host application

Changing a Property

Dimensioning a variable

Using variables in routines

Object Variables

Designing & Creating Forms

Working with Controls

Creating Custom Dialog Boxes

Userform Properties Methods & Events

Developing Excel Utilities with VBA

Error Handling

Using In-Built Excel Features in VBA

Working with Pivot Tables

Working with Charts

Understanding Excel's Events

Interacting with Other Applications

Creating and Using Add-Ins

Working with the Ribbon

Working with Shortcut Menus

Working with Shortcut Menus

Developing User Oriented Applications

VBA Editing & Debugging

Auto Macros

Error Handling

Connect to MS Access

Access Database & Retrieve Data from MS Access

Create Table & Query Data Filter DB using Query

Update and Modify DB

Create Single and Multiple Mapping Tables

Filter DB using Query

Query data grouping

Retrieve Data using Logical Access Query

Connect to Outlook using VBA

Query to retrieve Mail From, to and CC address

Retrieve Mail Subject and Time

Retrieve Mail Attachment