VBA MACROS Training

 >>  VBA MACROS Training

VBA MACROS Training


 (4.9) | 750 Ratings


Introduction


VBA MACROS Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

EXCEL VBA MACRO COURSE INTRODUCTION

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

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

EXCEL VBA MACRO COURSE INTRODUCTION

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

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry