Visual Basic Editor

1. Objects
2. Methods
3. Properties
4. Programming Tools
5. The Menu Bar

The Project Explorer

1. Using the Project Explorer

Using Constants

1. Excel Constants
2. Variable Constants

Excel Objects

1. Objects, Properties and Methods
2. Getting & Setting Properties
3. Calling Methods
4. Passing Arguments
5. Singular Objects & Collections of Objects

Using Visual Basic Functions

1. InputBox Function
2. MsgBox Function
3. Using a Set Statement

Building Formular Control Structures

1. If Then Janision Structures
2. Logical Operators
3. Select Case Janision Structures
4. Case Else
5. Comparison Operators with Select Case Structure
6. For Loops
7. Do Loops
8. While...Wend Statement

Running Code

1. Run mode and Design mode
2. Running Code from the development environment
3. Running Code from the host application

The Properties Window

1. Changing a Property

Variables

1. Dimensioning a variable
2. Using variables in routines
3. Object Variables

UserForms

1. Designing & Creating Forms
2. Working with Controls
3. Creating Custom Dialog Boxes
4. Userform Properties Methods & Events

Advanced VBA Programming Techniques

1. Developing Excel Utilities with VBA
2. Error Handling
3. Using In-Built Excel Features in VBA
4. Working with Pivot Tables
5. Working with Charts
6. Understanding Excel's Events
7. Interacting with Other Applications
8. Creating and Using Add-Ins

Developing Applications

1. Working with the Ribbon
2. Working with Shortcut Menus
3. Providing Help for Your Applications
4. Developing User Oriented Applications

Event Handling

1. VBA Editing & Debugging
2. Auto Macros
3. Error Handling

Connecting to Database

1. Connect to MS Access
2. Access Database & Retrieve Data from MS Access
3. Create Table & Query Data Filter DB using Query
4. Update and Modify DB
5. Create Single and Multiple Mapping Tables
6. Filter DB using Query
7. Query data grouping
8. Retrieve Data using Logical Access Query

Connect Excel to Outlook

1. Connect to Outlook using VBA
2. Query to retrieve Mail From, to and CC address
3. Retrieve Mail Subject and Time
4. Retrieve Mail Attachment