Professional VBA Course in Bangalore

  • Course Summary

VBA Macro Training in Marathahalli, Bangalore by RIA classroom offers students an inventive approach to learn VBA Macro in Bangalore. With experienced VBA Macro expert trainers and advanced lab Facilities to practice VBA Macro, students can finish VBA Macro training on constant situation. Our VBA Macro Training Institute in Bangalore is appraised as one of the Best VBA Macro Learning Center on Google.


Training strategy utilized for directing VBA Macro course incorporates simplicity of understanding VBA Macro ideas, most recent examples in VBA Macro classes and constant reasonable introduction. This guarantees understudies deciding on VBA Macro training in Marathahalli, Bangalore get value for money. Our VBA Macro course content is organized to cover all ideas under VBA Macro Training

VBA Macro Course Content

Our VBA Macro Course content is structured to cover all the modules within VBA Macro. From basic to advance, we give VBA Macro training in Bangalore in a manner that is easy to understand.

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

Get In Touch

Submit
Interested to join this course? Enquire Now Call Now

Pay Now with Pay you Money Pay U Money

Call+91 7204 081060