Master Microsoft Excel VBA

1 Macro VBA Introduction

    1.1 Macro VBA Introduction

    1.2 Macro recording and saving

    1.3 Macro security

    1.4  Visual Basic Editor

2 Writing Procedures

    2.1 VBA procedure types

    2.2 Scope of procedures

    2.3 Writing comments in VBA

    2.4 User define function

    2.5 Calling function procedure in sub procedure

3 Working with Dialog Box

    3.1 Customizing message box in VBA

     3.2 Input box in VBA

4 Basic Programming in VBA

    4.1 Variable, Data types, Constants in VBA

    4.2 VBA operators

5 Looping and Condition in VBA

    5.1 Decision making statement (IF condition)

    5.2 Decision making statement(switch case)

    5.3 Looping in VBA

6 Object Model and Events

    6.1 Object Model in VBA

    6.2 Working with Range object

    6.3 Worksheets Object and events

    6.4 Workbook object and events

    6.5 Application objects

7 Working with Arrays

    7.1 Array-single dimensional

    7.2 Array-double dimensional

8 Understanding and handling errors

    8.1 Error handling in VBA Code

    8.2 Type of errors in VBA

9 Working with charts

    9.1 Creating Chart using VBA

10 User Forms

    10.1 Creating User Forms

11 Excel Functions in VBA

    11.1 Using Excel Function Sum, Max, Min, VLOOKUP

    11.2    LOOKUP Function Returning Multiple Values

12 VBA Examples

    12.1 Recording and editing Macro to filter & copy data into another sheet

    12.2 Sort data using VBA Code

    12.3 Creating Pivot Table using VBA Macro

    12.4 Split data into multiple workbook

    12.5 Change case to upper, lower and proper