Location
Location

Uppal Hyderabad

Location
Phone

+91 70934 77157

VBA (MACROS)



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