VBA Macros Basic to Advance Training
INTRODUCTION TO VBA
1. What Is VBA?
2. What Can You Do with VBA?
3. VBA IDE
4. Recording the Macro
VISUAL BASIC EDITOR
1. The Project Explorer
2. The Properties Window
3. The VB editor windows
4. Creating and Removing Modules
VARIABLES IN VBA
1. What is Variables?
2. Using Non-Declared Variables
3. Variable Data Types
MESSAGEBOX AND INPUTBOX FUNCTIONS
1. Customising Msgboxes and Inputbox
2. Concatenating Boxes
3. Using Multiple Lines
4. Reading Cell Values into Messages
5. Asking Questions with Msgboxes / Inputbox
VBA WITH STATEMENTS
1. Writing a Simple With Statement
2. Creating More Complex References
3. Referencing other Objects
IF STATEMENTS
1. Simple If Statements
2. Single line Ifs
3. The Elseif Statement
4. Nesting Ifs
5. Combining Logical Tests
LOOPING IN VBA
1. Introduction to Loops and its Types
2. The Basic Do Loop Statement
3. Exiting from a Loop
4. Advanced Loop Examples
FOR NEXT LOOPS
1. Using Loop Counters
2. The Step Keyword
3. Exiting from a For Next Loop
4. Looping Through Items in a collection
FOR EACH LOOPS
1. The For Each Next Statement
2. Looping Over Cells
3. Nesting for Each Loops
CREATING FUNCTIONS
1. Writing a Simple Functions
2. Calling Functions
3. Creating Parameters
4. Optional Parameters
5. Rewriting Code to use Functions
ARRAYS IN VBA
1. Array Declaration
2. Assigning Values to an Array
3. Types of Array
4. One dimensional, Two dimensional and multi dimensional arrays
WORKING WITH SHEETS
1. Sheets and Types of Sheets
2. Manipulating Sheets:
3. Inserting and Deleting
4. Copying and Moving
5. Hiding and Unhiding
WORKING WITH WORKBOOKS
1. Referring to workbooks
2. Opening and Creating workbooks
3. Saving Workbooks
ERRORS HANDLING AND DEBUGGING
1. Types of Error:
2. Syntax Errors
3. Compile Errors
4. Runtime Errors
WORKING ON ACTIONS / EVENTS
1. Worksheet Level Events
2. Workbook Level Events
3. Application.OnTime
4. Working with Excel Range and Data
5. Worksheet and Workbook Operations,
6. Using Excel Functions in VBA
7. Volatile Functions
FILTER AND REPORTING
1. AutoFilter
2. Filter Object and Criteria(s)
3. Advanced Filters
4. Creating a PivotTable Report
5. PivotCaches and Naming
6. Adding PivotFields
7. Adding Fields for Calculation
8. Creating and Editing Charts
FORM CONTROLS
1. Understanding User forms and References
2. Combo box, Radio Button, Check box
3. Built in Dialog Boxes, Calendar
4. Working with Spin Buttons, Images
5. Reading data from Excel Sheets
6. Writing data to Excel Sheet
7. Project Study on GUI Pattern
MAIL FUNCTIONS – OUTLOOK
1. Using Outlook Namespace
2. Send automated mail
3. Outlook Configurations, MAPI
4. Filter Mails into Folders
5. Creating Contact
6. Create and Schedule Task
7. Export Mails Attachments in a specific location
WORKING WITH DATABASES
1. Introduction ADO
2. Various Connection Drivers
3. Database Connection and Recordset Object
4. Excel – Access Connectivity – Select, Retrieve, Insert Data Operations
5. Excel –SQL Connectivity - Select, Retrieve, Insert Data Operations
WORKING WITH WEB APIS
1. Form submissions, ROBOTs programming
2. Fill automated forms
3. Fill HTML Form using VBA
4. Robots programming
Interview Preparation
Training Certification
