About

VBA MACROS

Introduction to VBA

What is VBA

What can do with VBA

VBA IDE Recording the macro

Visual Basic Editor

The Project Explorer The Properties Window

The VB editor Windows

Creating and Removing Modules

Renaming Modules

Variables in VBA

What are variables?

Using Non Declared Variables

Variables data types

Modules & Class Modules

Messagebox and Inputbox Functions

Customizing Messagebox and Inputbox

Concatenating Boxes

Using Multiple Lines

Reading Cell Values into Messages

Asking Questions with Msgboxes / Inputbox

VBA Statements

Writing With Statenment

Creating complex references

Referencing objects

Conditional Statement

Simple IF statements

Single line ifs

The Esleif Statement

Nesting ifs

Combining Logical Tests

Select Case Statement

Looping IN VBA

Introduction to Loops and its Types

The Basic Do Loop Statement

Exiting from a Loop

Advanced Loop Examples

Do while Loop

For Next Loop

For Each Loop

Nested For Each Loop

Creating Functions

Writing a Simple Functions

Calling Functions

Creating Parameters

Optional Parameters

Rewrite Code to use Functions

Working with Sheets

Referring to workbooks

Opening and creating workbooks

Saving workbooks

Working with Workbooks

Servers

Report server basics

Web portal

Paginated Reports

Row level security

Data Gateways

Scheduled refresh

Resources (Rest API/Soap API’s/ URL Access)

Error Handling

Types of Error

Syntax Error

Compile Error

Runtime Error

Filter and Reporting

Autofilter

Filter Object and Criteria

Advanced Filter

From Controls

Understanding User Forms and references

Combo box, Radio button, Check box

Built in dialog boxes, Calenders

Working with Spin buttons, Images

Reading data from Excel Sheet

Mail Functions- Outlook

Using Outlook Namespace

Send automated mail

Outlook configuration, MAPI

Filter mails into folders

Creating Contact

Creating and Schedule task

Export mails attachments in a specific locations

Arrays in VBA

Arrays in VBA

Array Declaration

Assigning Values to an Array

Types of Array

One dimensional, Two dimensional and Multi dimensional arrays.