 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students will learn to create and edit macros, and gain an understanding of VBA code.
Prerequisites:
Excel 2000 Advanced or equivalent knowledge.
Unit 1 : Excel 2000 Visual Basic for Applications - 2 day course
Introduction to Visual Basic for Applications
Running a macro
Recording a macro
Examining module design
Unit 2 : Assigning macros
Specifying the location of recorded macros
Assigning macros to menus, buttons, and toolbars
Unit 3 : Creating decision-making code
The If ... Then decision structure
The If ... Then ... Else decision structure
The Select Case decision structure
Unit 4 : Using loop structures
Using a For... Next statement
Using a Do... Loop statement
Using a For Each... Next statement
Unit 5 : User-defined functions and variables
Creating user-defined functions
Creating variables
Unit 6 : Interactive macros
Creating a custom message box
Creating a custom input box
Extracting data from Excel
Unit 7 : Macro management
Personal Macro Workbook
Assigning Subprocedures to run automatically
Unit 8 : Debugging and testing code
Overview of debugging
Unit 9 : Programming basics
Coding
Variables
Procedures
Error handling
Naming conventions