VBA Course Contents

INTRODUCTION



ASSIGNING MACROS TO BUTTONS AND OBJECTS



VISUAL BASIC EDITOR / EXCEL OBJECT MODEL



EDITING MACROS



WORKBOOKS AND SHEETS



VARIABLES



BUILDING FORMULAE CONTROL STRUCTURES



ARRAYS



THE RANGE OBJECT



THE PROJECT EXPLORER



THE PROPERTIES WINDOW



USING CONSTANTS/VARIABLES



OBJECTS PROPERTIES AND METHODS



EXCEL OBJECTS



USING BASIC INPUT & OUTPUT FUNCTIONS



EVENT HANDLING



CONTROLS, DIALOGUE



CONTROL STRUCTURES



REAL TIME PROJECTS


WORKING WITH OUTLOOK & ACCESS