Automating your work using Macros

Program Contents :

Introduction To Excel VBA
The concept of excel VBA
Developer Tab
Understanding the VB Editor

Working with Constants and Vaiables

The Concept of Constants and Variables
Assigning values to Variables
Performing Arithmetic Operations

Using Message Box and Input Box

The Msgbox() function
The Inputbox() function

Using If Then Else

Conditional Operators
Logical Operators
Using If then else statement with Operators

Using For Next Loop

For Next Loop syntax
Looping
Examples

Do Loop

Overview
Formats of Do Loop
Examples

Select Case and End Case

Overview
Formats of Select Case
Examples

Examples

Examples using VBA commands

* * * * * * *