BEST VBA 01

MODULE 1

What Is Vba & How Vba Works With Excel

Quick Review of Macros
Introducing the Visual Basic Editor
Uses of record Macros
Understanding and creating modules

MODULE 2

Programming Concepts

VBA Sub and Function Procedures
How to create a message box
Write a Program to update and retrieve information using Input Box
Understanding and using Select Case statement
How do I define a variables and Rules for defining a Variables Name and Type
Creating And using Variables
Working with range Objects
How to save and Protect Modules

MODULE 3

Decision Makers

If……Then……Else
If……Then……ElseIf……If

MODULE 4

Other Kinds of Loops

Working with Do While u. Loop Procedure
Do…… Until Loop and Do…… Loop Until
Do……While loop and Do…… Loop While
For each…… Next
For……Next

MODULE 5

Workbook Obects Create or Add Single and Multiple Workbooks

Workbook Save and Save AS
Open Single and Multiple Workbooks
Close Specify and Multiple Workbooks
Activate From one workbook to another Workbook
Open Workbook from Specific Path
Get Workbook Name and Paths
Hide and Unhide for Single and Multiple Workbooks
Protect and Unprotect Worksheets

MODULE 6

Worksheet Objects insert a single and Multiple Worksheets

Delete Specific and multiple worksheets
Get Count of Worksheets
Select a Specific and all Worksheets
Get All Worksheets Name
Hide and Unhide For Single and Multiple Worksheets
Rename for Single and Multiple Worksheets
Protect and unprotect worksheets
Sort and Move worksheets
Calculate entire worksheet
Using VBA and worksheet Function

MODULE 7

Cell objects insert Single and multiple Row , Column and Cells

Delete Single and Multiple row, Column and Cells
Get Range or Address of Cell and Selection
Navigate from one Cell to another Cell
Select specific Range, Cell, Rows and Column
Types of Selection and Offset method
Insert Function In cell

MODULE 8

Reading and Writing Arrays

Defining Arrays
Arrays as Outputs
Arrays as inputs
The Arrays as a Collection
The Array as an Array

MODULE 9

Form Controls and User Forms (Create and Design an user Form)

Working With User Forms & User Forms Events Like List Box, Combo Box, Option Buttons, Check Box, Text Box, Labels, Command Button, Toggle Button.
How To Create Dynamic Dashboard On User Form With Different Controls
How To Link Various User Form With Each Other To Create A Complete Interface Between User And System

MODULE 10

VBA Programming Functions

Create a Sum Functions
Create Multiply Function
Create Count Function
Extract Text & Number
Proper Function
Vlookup Function
Square root Function
Public or Private function

MODULE 11

Excel VBA Power Programming for VBA Macros

Working with Dynamic Ranges. Protecting worksheets, Cells and Ranges. Working with Multiple Files. Opening &saving Files
How to Analyze Data On multi Worksheets And Build Summary sheets
how to Access the Windows File and Folder System to Open and Close Workbooks
How to protect your code Against Errors
How to use Excel And VBA to Create Basic Dash Boards
How to create Your own custom Business Worksheet Function in VBA
How to create Basic Report Generation Tools Using Excel VbA, Microsoft Word and PowerPoint
How to use the Excel Visual Basic Macro record Excel Tasks in VBA And then Interpret the code

MODULE 12

Connection between Excel VBA & other platforms

How To Establish Connection Between VBA And Power Presentation To Create Power Point Through VBA
How To Establish Connection Between Excel Vba And Outlooks Through Vba
How To Establish Connection Between Excel Vba And MS Word Through Vba

VBA Marco