Duration : 2 Months

Introduction to VBA

Introduction to Excel, Introduction to Programming VBA Overview and the IDE Quick Review of Macros Working with Macros, How to use Visual Basic Editor (Programming Environment)

Advantage of VBA

An easy-to-use and versatile language, Integrated with off-the-shelf products

Understanding the VBA Editor Modules and Macros

The Visual Basic Editor Parts of the VBA Editor Modules and Macros, About VBA Forms, Sub Procedures & Modules Creating Forms, Using Controls and their Properties Running VBA Forms in Excel

VBA Syntax and Grammar 

Objects – The Grammar, Using Properties and Methods Understanding Parameters The Object Browser, Understanding object hierarchy Tools for better coding, Moving to Other Cells Editing Specific Cells

VBA Syntax and Grammer

Objects – The Grammar, Using Properties and Methods, Understanding Parameters, The Object Browser, Understanding object hierarchy, Tools for better coding, Moving to Other Cells, Editing Specific Cells

Variables, Array and Constants

Using the Immediate Window, Gaining greater control through the immediate window, Formatting Cells, Using Variables, Constants, Object Variables, Dimensioning and usage of variables, Displaying data and obtaining data from the user

Storing Data in a Variable

How and when to declare variables, Selecting data types, Fixed and dynamic arrays, Constants

Control Structure and Program Flow

IF (ElseIf, Else), Select Case(), For Next Loop, For Each Loop(), Do Until Loop and Do While Loop, With, End With, Nesting Code

Building Procedures

Creating Sub and Function procedures, Calling procedures, Passing arguments to procedures

Building Intuitive User Interface

Communicating with the user through the message box, Gathering user information with the input box, Utilizing the File Dialog object and Dialogs collections

User Form

Command buttons, List and Combo boxes, Labels, Option buttons, Check boxes, Text boxes, Frames, Adding more functionality with advanced ActiveX control

Fonts and Background

Using Font Property in cells, Using Various Background Properties in Excel VBA, Creating a Counter, String Handling, Using Left, Right, Instr, Mid and Len Functions in VBA, Range Selection and Manipulation

Workbook and WorkSheets

Workbook and Worksheet Object, Range Object and Cell Properties, Methods and Properties, Assigning Objects, Using Name Arguments

Array

What is Array& why use array, Declaring an Array, Sorting Data in Array, 2-Dimention Array, Dynamic Array,

Functions

Using Excel Worksheet Functions in VBA, VBA Functions, User-Defined Functions, Adding Help to User Defined Functions, Declaring Variables Using Excel Worksheet Functions in VBA, VBA Functions, User-Defined Functions, Adding Help to User Defined Functions, Declaring Variables

Click Here To Download Excel VBA Syllabus and Fee