VBA Macros
INTRODUCTION TO VBA
What Is VBA?
What Can You Do with VBA?
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 is Variables?
Using Non-Declared Variables
Pvt vs Public
Option Explicit
Difference – DIM vs. SET
Variable Data Types
VBA WITH STATEMENTS
Writing a Simple With Statement
Creating More Complex References
Referencing other Objects
IF STATEMENTS
Simple If Statements
The Elseif Statement
Nesting Ifs
Combining Logical Tests
FILTER AND REPORTING
AutoFilter
Filter Object and Criteria(s)
Advanced Filters
Creating a PivotTable Report
PivotCaches and Naming
Adding PivotFields
Adding Fields for Calculation
VBA & MACROS Course
Working with the objects Events
Object Reference Model
Range
Cell objects
Range Properties and Methods
Range Count Property
Mergecell & range
Range Select
Selection of Rows and Columns
Difference between Dim and Set
Understanding Worksheet Object
Worksheet properties and methods
Understanding workbook object
How to Delete a workbook
Object Browser
Find the Last Row, Column, or Cell on a Sheet
Manipulating Excel Objects
Offset
Application of Offset
Offset property in VBA
LOOPING IN VBA
Introduction to Loops and its Types
The Basic Do Loop Statement
Exiting from a Loop
Advanced Loop Examples
DO WHILE
DO UNTIL
FOR NEXT LOOPS
Using Loop Counters
The Step Keyword
Exiting from a For Next Loop
FOR EACH LOOPS
The For Each Next Statement
Looping Over Cells
Nesting for Each Loops
Working With Excel VBA Functions
How to create functions
How to use conditions in functions
Using conditions If...Then....Else
User Defined Functions
Creating Excel Add-ins
How to create Excel Add-ins
​
ARRAYS IN VBA
Array Declaration
Assigning Values to an Array
Types of Array
One dimensional, Two dimensional and multi dimensional arrays
WORKING WITH SHEETS
Sheets and Types of Sheets
Manipulating Sheets
Inserting and Deleting
Copying and Moving
Hiding and Unhiding
WORKING WITH WORKBOOKS
Referring to workbooks
Opening and Creating workbooks
Saving Workbooks
ERRORS HANDLING AND DEBUGGING
Types of Errors
Error Handling
Debugging
WORKING ON ACTIONS / EVENTS
Creating Events(Open Event)
Close Events
Workbook Activate Sheet Events
Workbook Activate Events
Worksheet ActivateDec Events
Application Events
File Dialog
File Picker
Folder Picker
FILE SYSTEM OBJECTS(Folders)
Folders
Sub folders
Form Controls and Active X Controls
USERFORMS
MAIL FUNCTIONS – OUTLOOK
Working on a Live Project-15
Interview Questions
MATERIAL