Excel VBA
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