|
Course overview
On this course delegates will learn how to record and edit macro code,
and to control Excel using the Visual Basic for Applications programming
language. Delegates will be able to design, write and debug macros, create
a dialog box and control structures, and create custom Excel functions.
Who should attend
This course is aimed at experienced Excel users who have no previous VBA
experience.
|
|
Course contents (1 day)
Macros
What is a Macro?
Recording Macros
Running Macros from Shortcut Keys
Running Macros from Toolbar Buttons
Running Macros from Worksheet Buttons
The Visual Basic Editor
Viewing Code
The Personal Macro Workbook
Modules and Procedures
Understanding and Editing Code
Code Layout
Comments or Remarks
Object Methods and Properties
Keeping Code Tidy
Toggling Code
Absolute and Relative References
Variables and Variable Declaration
Data Types
Exploring Code
The Object Browser
Testing code in the Immediate Window
Interactive Control Structures
The Inputbox function
The Msgbox statement and function
|
Controlling the flow of code
Using the If Statement for Decision Making
The Select Case Statement
Looping Structures
Do Until and While
For Next and For Each
Handling Errors
Using Line Labels
The On Error, Goto and Resume Key Words
Trapping Errors
Setting Break Points and Stepping
Using the Locals and Watch Windows
Function Procedures
Creating Function Procedures
Using on a worksheet
Using with Code
Course contents (2 days)
Topics listed for the 1 day course
User Designed Forms
Different scopes for variables
Creating complex tasks
Workshop session on an application that delegates would like to develop
(or we will provide examples)
|
