Excel VBA

1.Overview - Excel VBA
What is VBA
Why VBA?
Application of VBA
Rules for Creating Variables

2.VBA Editor
Access the VBA Editor
What is Macros?
Importance of Macros in Excel

3.Data Types
Numeric Data Types
Non-Numeric Data Types

4.Variables
Syntax for VBA variable
How to Execute the Variables

5.VBA Constant

6.Arrays
Types of Array
Array Dimensions
Advantages of Array
Testing the Application

7.Arithmetic Operators
Bit-Shift Operation
Bitwise Operations

8.String Operator

9.Logical operator

10.Compression Operator

11.If Else If Statement
If Then statement
 If Then Else statement
If ElseIf statement

12.Excel VBA Range
Range Property

1.Overview - Excel VBA
What is VBA
Why VBA?
Application of VBA
Rules for Creating Variables

2.VBA Editor
Access the VBA Editor
What is Macros?
Importance of Macros in Excel

3.Data Types
Numeric Data Types
Non-Numeric Data Types

4.Variables
Syntax for VBA variable
How to Execute the Variables

5.VBA Constant

6.Arrays
Types of Array
Array Dimensions
Advantages of Array
Testing the Application

7.Arithmetic Operators
Bit-Shift Operation
Bitwise Operations

8.String Operator

9.Logical operator

10.Compression Operator

11.If Else If Statement
If Then statement
 If Then Else statement
If ElseIf statement

12.Excel VBA Range
Range Property