Best VBA Macro Courses in bangalore

By: Ayaz Alam


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 possibly asked by the interviewer during the job selection process; this provides confidence to the students while facing job interviews.

RIA Institute provides Classroom training, 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.

Microsoft Excel VBA
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

Article Directory: http://www.articletrunk.com

| More

Please Rate this Article

 

Not yet Rated

Click the XML Icon Above to Receive Education Articles Articles Via RSS!


Powered by Article Dashboard