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 Variables

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
* * * * * * *