Comments

Introduction and Changing Cell Values

Adding a text to a cell

Dealing with Named Ranges

Value vs Text Properties

Row and Column properties

Select Method

Count Property

Address Property

Formula Property

Number Format Property

Font Property

Cells Object Introduction

Effecting cells positionally within a range

Combining Range and cells objects

Selecting Sheets

Adding Sheets

Sheets vs Worksheets

Copying Sheets

Moving Sheets

Deleting Sheets

Variables Intro

Variable Data Type

Declaring Variables

Forcing Variable Declaration

Object Variables

Calling a procedure from another and variable scope

Public and Private variables

Declaring Constants

referring to workbooks

Closing Workbooks

Adding and Saving workbooks Part 1- Save method

Adding and Saving Workbooks Part 2-Workbook Save As method

Opening Workbooks

Finding the last row

Finding the Last Column

Finding the Next Row

With Statement

Comparison Operators in Excel VBA

Simple IF Statement

IF THEN ELSE Statement

IF THEN ELSEIF Structure

Using Nested IFs

OR AND Logical Operators

NOT Logical operator

If Statements -Exercise

Select case statement-Single case statements

Nested Case Statements

Case Statement -Exercise

GOTO and Labels

Loops Introduction

For Next loop

Exit for Statement

For Next Loop -Exercise

For each Loop Part 1

For each Loop Part 2

FOR EACH Loop-Exercise

Do Loop - Introduction

Do Loop -Simple Example

Do until with Example

Do While -Simple Example

Do While vs Do Until - Movies Example

Exit Do Statement

Do Loop -Exercise

Message box-Introduction

Message Box Inputs

Message box -Capturing User Input

Adding a new line to a VBA String

Message box -Exercise

Input Box - Introduction

Input Box - First Example -Capturing a user's Name

Input Box - Employee Database Example Part 1

Input Box - Employee Database Example Part 2

Input box-Exercise

Error Handling-Introduction

Different error types in action

On Error GoTo

On Error Goto 0

The Err Object

Setting a breakpoint

Events - Introduction

Worksheet Selection Change Event

Worksheet activate Event

Worksheet De-activate event

Worksheet Before delete event

Worksheet Before Double Click Event

Worksheet Before Right-Click event

Worksheet Calculate Event

Enabling and Disabling events

Worksheet Change event

Follow Hyperlink Event

Worksheet events -Exercise

Workbook Open Event

Workbook Activate event

Workbook Before Save event

Workbook After Save event

Workbook Before Close event

Workbook Before print event

Workbook De-activate event

Workbook New Chart event

Workbook New sheet event

Workbook sheet calculate event

Workbook Sheet de-activate event

Workbook Follow Hyperlink event

Workbook Window Activate event

Workbook Window De-activate event

Workbook Window Resize event

Workbook Events-Exercise