VBA Macro

Home / VBA Macro

VBA Macro Training in Bangalore

LEARN VBA MACRO FROM RIA INSTITUTE OF TECHNOLOGY

RIA institute provides Best VBA Macro training Institute in Marathahalli, Bangalore by experienced industry professionals and the VBA Macro Training Institute in Bangalore is well equipped with advanced labs. Trainers working in VBA Macro for more than 5 years are carefully chosen to conduct high quality VBA Macro Training in Marathahalli, Bangalore so that the students can benefit from real time scenarios. Instructors offering VBA Macro Training in Bangalore have practical knowledge as they implement their knowledge and expertise in day to day work.

Course content by best VBA Macro Training Institute in Bangalore is carefully crafted to match the industry requirements. The topics covered in VBA Macro Training include latest and best real-time examples that are aimed to help students in getting the right job so after the completion of Training. Our expert instructors will highlight the Key topics from VBA Macro Training based on the questions that can be possible asked by the interviewer during the job selection process; this provides confidence to the students while facing job interviews.

RIA Institute provides Class room trainings, online training, Weekend classed and Fast track course for VBA Macro Training in Bangalore. Students have the option to select the course timings according to their convenience. Once the VBA Macro Training course timings are fixed with the instructor, students are required to complete the course in the same schedule. Our schedule for VBA Macro Training in Bangalore is very flexible as we provide training in weekdays in morning and evening for students who cannot attend VBA Macro Training in Bangalore during weekends due to their work schedule.

Talk to our VBA Macro Training Experts now for a free Demo.

Related Courses

SAS


WE COVER THE FOLLOWING TOPICS IN VBA MACRO TRAINING

MACRO- VBA Course Content
 

Microsoft Excel VBA 
Duration- 20 hrs
1 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

VBA MACRO TRAINER PROFILE

Best VBA Macro Trainers in Bangalore

  • 10 years of relavant work experience in VBA Macro Training
  • Real time Traning on VBA Macro Projects
  • 45 hrs of Job Oriented Training in Bangalore
  • Successfully Trained more than 1000+ Professionals

OUR VBA MACRO TRAINING CENTERS IN BANGALORE

Best VBA Macro Training in Marathalalli

  • Near Marathahalli Bridge

Best VBA Macro Training in RT Nagar

  • Near LG Showroom

JOB ORIENTED VBA MACRO TRAINING IN BANGALORE

  • 1000s of Students are already working in Top MNC
  • Placement oriented course curriculum
  • Interview Tips and preparation

 

VBA Macro Training Batch size in Bangalore

  • 10 Seats maximum per batch

 

VBA Macro Training in Bangalore on Weekends

  • 10 Seats maximum per batch

 

Fast Track VBA Macro Training Options

  • 5 Seats maximum per batch

 

VBA Macro Training Cost

  • Best in class fee structure with quality training

JOIN TODAY







CONTACT US

MARATHAHALLI BRANCH :

# 3/76, Shiva Building, Outer Ring Road,
Marathahalli, Bangalore - 560 037. 
 Opp Kala Mandir 
 +91 97394 31060

RT NAGAR BRANCH :

# 10/23, 2nd Floor, 5th Main Road, 
Ganga Nagar, Bangalore - 560 032. 
 Near LG Showroom

CONNECT WITH US

CONNECT WITH US

Note - We do not provide any SAP software or SAP copyrighted training materials while imparting courses and are
not affiliated with SAP.

RIA Institute of Technology © 2017 | All Rights Reserved