India-flagINDIA : +91-9393 002 123   usa-flagUSA : 201-710-8393
Call Me Back

training courses

VBA Macros Training

EXR-1
  • INTRODUCTION OF MACROS
  • INTRODUCTION OF VB EDITOR
  • INTRODUTION OF PROJECT EXPLORER
  • INTRODUTION OF PROJECT PROPETIES
  • INTRODUTION OF PROJECT MODULES
  • INTRODUTION OF SUB PROCEDURE
  • SIMPLE CODING ON CELL COLOR,BORDER, ALIGNMENTS
  • DIFFERENCE BETWEEN CELLS AND RANGE ARGUMENTS
  • ADVANTAGES OF USING CELLS ARGUMENTS
EXR- 2
  • DIMENTION(Dim) DECLARATION
  • INTEGER,LONG,SINGLE,DOUBLE DECLARATION
  • STRING VARIABLES DECLARATION
  • INPUT BOX
  • MSGBOX
  • INTRODUCTION OF 'FOR' LOOP
  • WORKING WITH CELLS USING LOOP
  • WORKING WITH TWO RANGE'S OR MULTIPLE RANGE'S
EXR-3
  • IF CONDITION
  • WORKING WITH SHEET TO SHEET
  • WORKING WITH SHEET TO MULTIPLE SHEETS
  • WORKING WITH WORKBOOK 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
EXR-4
  • MACROS CREATE, EDIT,DELETE
  • USING MULTIPLE LOOPS
  • GOTO COMMAND
  • SAMPLE PROJECT. BASED ON COVERED TOPICS
EXR-5
  • FORM CONTROLS
  • COMMAND BUTTON
  • LIST BOX
  • HLOOKUP
  • COMBO BOX
  • MATCH
  • OPTION BUTTON
  • ACTIVE X CONTROLS
EXR-6
  • USERFORMS
  • TOOL BOX
  • USERFORM PROPERTIES
  • USING OF LABEL
  • USING OF COMMAND BUTTON
  • USING OF OPTION BUTTON
  • USING OF CHECK BOX BUTTON
  • USING OF COMBO BOX BUTTON
EXR-7
  • SAMPLE PROJECT
  • BASED ON COVERED TOPICS
EXR-8
  • USER FORM TO USER FORM INTEGRATION
  • USER FORM TO SUB PROCEDURE INTEGRATION
  • USER FORM PROTECTION
  • VBA CODING PROTECTION
EXR-9
  • RECORD MACRO
  • EDITING RECORDED CODING
  • HOW TO USE RECORDED CODING USE TO OUR PROGRAMING
  • MACROS
  • MACROS IN ALL OPEN WORKBOOKS
If you want to know more about VBA MacrosTraining do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com