What is VBA?

Visual Basic for Applications (VBA) is a computer programming language developed and owned by Microsoft. VBA is used to automate tasks and perform several other functions beyond creating and organizing spreadsheets.


Learn More


\"\"



What is Macro?

Macro is single instruction that expands automatically into a set of instructions to perform a particular task.


Read More


What is VBA?

VBA is a powerful and sophisticated built-in programming language allows you to write your own functions.


Read More


VBA Editor

The Visual Basic for Applications editor, also called the VBA editor, VB editor, or VBE, is an interface for creating scripts.


Read More


Cells Method & Property

In this session we will Font, Alignment and Cells Property.


Read More


Variable In VBA

Variables are specific values that are stored in a computer memory or storage system.


Read More


InputBox & Msgbox

Input box is used to get input from user and msg box to view output.


Read More



Worksheet Methods

Includes Add, Delete, Rename, Hide, Tab Color, Password, Copy and Move sheets.


Read More


Workbook Methods

Includes add, open, save, close, activate, password to workbooks.


Read More


Conditional Statement

This session include if , nested if, elseif and case as well as case is


Read More


Loop in VBA

The main types of loops in VBA include For Next loop, For Each loop, Do While loop, Do Until loop.


Read More


Error Handling

Error-handling routines rely on the value in the Number property of the Err object to determine the cause of the error.


Read More


VBA Events

VBA Events allow you to run a macro when a specific event occurs..


Read More



Auto Filter

In VBA, you can use Excel\’s AutoFilter to filter a range of cells or an Excel table.


Read More


VBA Functions

A function is a group of reusable code which can be called anywhere in your program.


Read More


VBA Array & Collection

Collections are simpler to use than arrays. Arrays are more useful when the number of items is fixed.


Read More


VBA Application

This session includes On Time, Display, Onkey.


Read More


VBA User Form

A User Form is a custom-built dialog box that makes a user data entry more controllable and easier to use for the user.


Read More


VBA Tips

Session includes VBA tips, updates etc.


Read More