Excel VBA Introduction |
||
PREREQUISITES
· A high proficiency of Microsoft Excel is essential, or completion of our 20 day Advanced MS Excel course. BENEFITS · At the end of the course the delegate will have covered the fundamentals of VBA, including: · working with procedures and functions · understanding objects · Using expressions, variables and intrinsic functions.
COURSE CONTENT
|
||
INTRODUCTION
ASSIGNING MACROS TO BUTTONS AND OBJECTS
VISUAL BASIC EDITOR
EDITING MACROS
THE RANGE OBJECT
|
WORKBOOKS AND SHEETS
THE PROJECT EXPLORER
THE PROPERTIES WINDOW
USING CONSTANTS
OBJECTS PROPERTIES AND METHODS
EXCEL OBJECTS
VARIABLES
USING BASIC FUNCTIONS
|
|
BUILDING FORMULAE CONTROL STRUCTURES
EVENT HANDLING
CONTROLS, DIALOGUE
CONTROL STRUCTURES
|