Course Content:
Exercise -1
Introduction to MACROS
Introduction to VB Editor
Introduction of Project Explorer, Properties Window, Project Modules
Introduction to Sub Procedure
Simple Coding on Cell color,Border,Alignments
Difference between Cells and Range,Advantages of using Cells Arguments
Exercise -2
Dimenson (Dim) Declaration
Datatypes ( Integer, long, Single, Double, String,...etc)
Variables, Constants, Operators,Dialogboxes ( Input , Msgbox)
Control Statements ( IF - ELSE, ELSE IF, NESTED IF, CASE STATEMENT,GOTO)
Loops ( WHILE, DO-WHILE , FOR LOOP)
Working with Range and Multiple Ranges,Working with Cells with loop
Exercise -3
Working with Sheet to Sheet , Sheet to Multiple Sheets
Working with Worbook to Workbook
Sheets Creation, Deletion Day
Workbook Creation, Save Location
Worksheet name assign with a Sheet Range Based
Workbook name assign with a Sheet Range Based,Sagrication of data in Different Sheets.
Exercise -4
Macros Create , Edit, Delete
Sample Project Based on Covered Topics
Exercise -5
Form Controls, Command Button , Listbox , VLOOKUP, HLOOKUP
Combobox, Match , Option Button, Active X Controls
Exercise -6
UserForms, Toolbox, UserForm Properties, Events, Working with Controls
Exercise -7
UserForm to UserForm Integration
UserForm to Sub Procedure Integration , UserForm Protection, VBA Coding Protection
Sample Project
