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.
What is Macro?
Macro is single instruction that expands automatically into a set of instructions to perform a particular task.
What is VBA?
VBA is a powerful and sophisticated built-in programming language allows you to write your own functions.
VBA Editor
The Visual Basic for Applications editor, also called the VBA editor, VB editor, or VBE, is an interface for creating scripts.
Cells Method & Property
In this session we will Font, Alignment and Cells Property.
Variable In VBA
Variables are specific values that are stored in a computer memory or storage system.
InputBox & Msgbox
Input box is used to get input from user and msg box to view output.
Worksheet Methods
Includes Add, Delete, Rename, Hide, Tab Color, Password, Copy and Move sheets.
Workbook Methods
Includes add, open, save, close, activate, password to workbooks.
Conditional Statement
This session include if , nested if, elseif and case as well as case is
Loop in VBA
The main types of loops in VBA include For Next loop, For Each loop, Do While loop, Do Until loop.
Error Handling
Error-handling routines rely on the value in the Number property of the Err object to determine the cause of the error.
VBA Events
VBA Events allow you to run a macro when a specific event occurs..
Auto Filter
In VBA, you can use Excel's AutoFilter to filter a range of cells or an Excel table.
VBA Functions
A function is a group of reusable code which can be called anywhere in your program.
VBA Array & Collection
Collections are simpler to use than arrays. Arrays are more useful when the number of items is fixed.
VBA Application
This session includes On Time, Display, Onkey.
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.
VBA Tips
Session includes VBA tips, updates etc.