VBA With Macros Training

SECTION 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

SECTION 2 : VBA IDE

OPENING THE EXCEL VBA IDE

MENU BAR

TOOLBAR

PROJECT WINDOW

CODE WINDOW

IMMEDIATE WINDOW

CUSTOMIZING THE VBE

SECTION 3 : Getting Started With Macro

RECORDING THE MACRO

EXAMINING THE MACRO

SAVING WORKBOOKS THAT CONTAIN MACROS

SECTION 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

SECTION 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

SECTION 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

SECTION 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

SECTION 8 : Handling Errors

TYPES OF ERRORS IN VBA

USING THE ON ERROR GOTO STATEMENT

USING THE RESUME STATEMENT

WORKING WITH THE ERR OBJECT

SECTION 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

SECTION 9 : Arrays

DECLARING ARRAYS

SPECIFYING LIMITS

ARRAY FUNCTION

TWO DIMENSIONAL ARRAYS

MULTI DIMENSIONAL ARRAYS

DYNAMIC ARRAYS

SECTION 9 : The Application Object

GLOBALS

THE ACTIVE PROPERTIES

DISPLAY ALERTS

SCREEN UPDATING

EVALUATE

STATUSBAR

SEND KEYS

ONTIME & ON KEY

SECTION 9 : Data Lists

SORTING A RANGE

CREATING A TABLE

SORTING A TABLE

AUTOFILTER