VBA Macro

Below is the detailed course content for VBA Macro Training

Duration- 20 hrs1 Introduction to VBA

  • WHAT IS VBA?
  • INTRODUCTION TO ANOTHER LANGUAGES
  • VBA: AN EVENT DRIVEN PROGRAMMING
  • VBA: AN OBJECT BASED PROGRAMMING
  • ADVANTAGES AND DISADVANTAGES OF VBA
  • OBJECTS, PROCEDURES AND PROPERTIES

2 VBA IDE

  • OPENING THE EXCEL VBA IDE
  • MENU BAR
  • TOOLBAR
  • PROJECT WINDOW
  • CODE WINDOW
  • IMMEDIATE WINDOW
  • CUSTOMIZING THE VBE

3Getting Started With Macro

  • RECORDING THE MACRO
  • EXAMINING THE MACRO
  • SAVING WORKBOOKS THAT CONTAIN MACROS

4 Fundamentals of VBA Language

  • VARIABLE & CONSTANTS
  • KEYWORDS
  • DATA TYPES
  • PROCEDURES: SUB AND FUNCTION
  • ARGUMENTS
  • LOCAL VS GLOBAL VARIABLE DECLARATION
  • PROCEDURES: PUBLIC OR PRIVATE
  • COMMENTS

5 Control Flow & Loops Statements

  • RELATIONAL AND LOGICAL OPERATORS
  • IF….THEN
  • IF….THEN….ELSE
  • IF….THEN….ELSEIF….ELSE
  • SELECT CASE ( WITH TO AND WITH IS)
  • DO WHILE….LOOP
  • DOLOOP….WHILE
  • DO UNTIL….LOOP
  • DOLOOP….UNTIL
  • FOR….NEXT
  • FOR EACH….NEXT
  • WHILE….WEND
  • THE EXIT STATEMENT

6 Using VBA and Worksheet Functions

  • VB FUNCTIONS
  • EXCEL FUNCTIONS
  • THE WORKBOOKS COLLECTION
  • THE SHEETS COLLECTION
  • ACTIVATE AND SELECT
  • RANGE PROPERTY
  • CELLS PROPERTY
  • OffSET PROPERTY
  • RESIZE PROPERTY
  • CURRENTREGION PROPERTY
  • COLUMNS AND ROWS PROPERTIES
  • REFERENCING RANGES IN OTHER SHEETS
  • USING THE UNION AND INTERSECT METHODS
  • USING THE ISEMPTY FUNCTION
  • USING THE AREAS COLLECTION
  • TRANSFERRING VALUES BETWEEN ARRAYS AND RANGES

7 Working with Dialog Boxes and Form Objects

  • USING LABELS
  • USING TEXT BOXES
  • USING THE COMMAND BUTTON CONTROL
  • USING LIST BOXES
  • USING COMBO BOXES
  • USING CHECK BOXES
  • USING RADIO BUTTONS
  • USING TOGGLE BUTTONS
  • USING FRAMES
  • USING MESSAGE BOXES
  • TAKING INPUT USING INPUT BOXES
  • TABSTRIP
  • USING A SCROLLBAR AS A SLIDER TO SELECT VALUES
  • ADDING HELP TIPS TO CONTROLS
  • TAB ORDER
  • COLOURING THE ACTIVE CONTROL
  • TRANSPARENT FORMS
  • WORKING WITH MENUS AND TOOLBARS
  • CREATING MENUS AND TOOLBARS

8 Handling Errors

  • TYPES OF ERRORS IN VBA
  • USING THE ON ERROR GOTO STATEMENT
  • USING THE RESUME STATEMENT
  • WORKING WITH THE ERR OBJECT

9 The Excel Object Model

  • INTRODUCING CLASSES AND OBJECTS
  • THE OBJECT HIERARCHY
  • COLLECTIONS
  • REFERRING TO OBJECTS
  • NAVIGATING THROUGH THE HIERARCHY
  • OBJECT PROPERTIES AND METHODS
  • EVENTS
  • USING THE WITH…END WITH STATEMENT

10 Arrays

  • DECLARING ARRAYS
  • SPECIFYING LIMITS
  • ARRAY FUNCTION
  • TWO DIMENSIONAL ARRAYS
  • MULTI DIMENSIONAL ARRAYS
  • DYNAMIC ARRAYS

11 The Application Object

  • GLOBALS
  • THE ACTIVE PROPERTIES
  • DISPLAY ALERTS
  • SCREEN UPDATING
  • EVALUATE
  • STATUSBAR
  • SEND KEYS
  • ONTIME & ON KEY

12 Data Lists

  • SORTING A RANGE
  • CREATING A TABLE
  • SORTING A TABLE
  • AUTOFILTER

Best VBA Macro Training institute in Bangalore

  • Trained over 2000 students
  • Over a Decade of experience in Training industry
  • Experienced and Certified trainers
  • Practical and Theory training
  • Flexible Batch timings
CONTACT ME