VBA MACROS

Introduction

What is VBA?

What can you do with VBA

Advantages

Disadvantages

Working with Visual Basic Editor

Components of VBE

Customizing the VBA Environment

Introducing the Excel Object Model

Object hierarchy

Referring to Objects

Object Properties and Methods

VBA Sub and Function Procedures

Understanding Sub v/s Functions

Writing Simple VBA Macros

Working with Subs and Functions

VBA Language Elements

Using Comments in VBA Macros

Variables, Constants and Datatypes

Understanding Scope of Variables

Assignment Statements Using Labels and Go to Statements

Working with Arrays

Introduction to Arrays

Static Arrays

Dynamic Arrays

One Dimensional Arrays

Two Dimensional Arrays

Multi-dimensional Arrays

Conditional Statements

If

If End If

If Else EndIf

Elseif Ladder

Nested If Conditions

Select Case Statements

Looping Structure

For Loops

Do Loops

Using VBA and Worksheet Functions

Using Built-In VBA Functions

Using Worksheet Functions in VBA

Using Custom Functions

Automatic Procedures and Events

Working with Worksheet Events

Working with Workbook Events

Userform Module

Creating A UserForm

Using Controls in UserForms

Understanding Events used in UserForms

Modifying the UserForms

Inserting & Modifying of the Data from UserForms

Error Handling Techniques

Types of Errors

Using Breakpoints

Debugging Techniques

Simple Dialogue Boxes

UsingMsgBox Function

UsingInputBox Function

Working with FileDialog

Working GetOpenFilname Method

Working GetSaveAsFilename Method

Working with other Excel Objects

Working with Charts in VBA

Working with Pivot Tables and Charts in VBA