Loader
whatsapp

TRAINING

Enroll Now sas-di-training

Online Training

Corporate Training

Classroom

VBA MACROS CONTENT :

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

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services