VBA Programming Training Training

INTRODUCTION TO VBA

VARIABLES, DATA TYPES AND CONSTANTS

OBJECTS AND COLLECTIONS

WORKING WITH RANGES

Decision Making in VBA

Looping in VBA

WORKING WITH ARRAYS

PROCEDURES WITH WORKSHEET EVENTS

AUTOMATING PROCEDURES WITH WORKBOOK EVENTS

WORKING WITH DUPLICATE ITEMS AND RECORDS

PROGRAMMING CHARTS

USER-DEFINED FUNCTIONS

DEBUGGING YOUR CODE

CREATING USERFORMS

DATA ACCESS WITH ACTIVEX DATA OBJECTS (SQL Database)

INTEGRATING WITH OTHER MS OFFICE APPLICATIONS