|
SYNOPSIS:
This course introduces the skills necessary to enable delegates to automate
simple tasks and routines. It introduces the variability within automated
processes, interacting with users via dialog boxes and the power and flexibility
necessary for automated processes.
PREREQUISITES:
Users with a sound knowledge (at least up to intermediate level) of Excel.
OBJECTIVES:
l Macro Basics
l Introduction to VBA
l Object-Oriented Programming
l Error Handling
l User Interface Design & Programming
DURATION:
Two Days
|
THIS MODULE INCLUDES:
Macro Basics
Introducing the VBA environment; What is a Macro; Recording, running and
editing macros; Assigning macros to a command button, graphics object
and tools menu bar; Recording code into an existing macro.
Introduction to VBA
Modules; Procedures; Principles and concepts of Programming; Data types,
variables and constants; Program Flow Control; Commands and Statements;
If..Then..Else; Do..Loop, While and Until; For..Next Statements.
Object-Oriented Programming
Controlling objects and their Properties; Object Variables; Performing
Actions with Methods; The Range Object; Activating Workbooks and Worksheets.
Error Handling
Stepping through Code; Finding Syntax Errors; Using Debug, Print;
Building Error-trapping Routines.
User Interface Design & Programming
Built-in dialogue boxes; Controls; Inviting and Dealing with User Inputs;
Assigning Procedures to a Dialog Box.
|
