Creating & Recording a Macro - First step towards learning Macros programming is to learn how to create & record macros. This is the 1st step towards macro programming.
Executing Macros through shortcuts and command buttons - This is using such features based on user requirements.
Editing recorded syntax - How to edit or write your own Macro programs.
Modules - Learn about modules which is an excellent feature of VBA programming.
Procedures - write & practice programming procedures. Understand their flow.
Sub Procedures - write & practice programming procedures.
Functions - There are certain inbuilt or user defined functions. Explore those functions.
Excel VBA tutorial - VBA tutorial will help you proceed in a step by step approach.
Objects and collections - An object is a special type of variable that contains both data and codes. A collection is a group of objects of the same class. The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.
Workbook and workbook objects - A workbook is the same as an Excel file. The Workbook collection contains all the workbooks that are currently opened. Inside of a workbook contains at least one worksheet.
Range object & cells property - Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D.
Methods & properties -Each object contains its own methods & properties. A Property represents a built-in or user-defined characteristic of object.
Object variables and arguments - Sometime a method takes more than one argument. For example, the Open method for the Workbook object, takes 12 arguments. To open a workbook with password protection, you would need to write the code.
If Case, Loop Case & Select Case -Looping, Sub looping, looping through a range, For.Next loop etc. Execute multiple conditions with select statement.
Rs. 6,000/- Per Person.