Excel - Programming in VBA 2000/2002

Cost: $1090.00   Duration: 2 days

Prerequisite
This course is designed for participants who have completed the Microsoft Excel 2000/2002 Level 3 course or equivalent knowledge.

Objectives
To increase your productivity by providing the skills and knowledge to program VBA in Microsoft Excel 2000/2002 effectively.

Methodology
Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

At Drake Training, we've made it easier for students to complete their Microsoft applications training by combining all versions into one single session.

Users of the various Microsoft 2000, XP and 2003 applications will find that our courses prepare them to use all three products, which also means that our courses run more frequently since individual versions are not run in isolation. Our Office courses are also aligned to Microsoft Office Specialist certifications.

Content:

Recorded Macros
Recording a Simple Macro
Running a Recorded Macro
Relative Recording
Running a Relative Recording
Viewing the Module
Modifying a Recorded Macro

Recorder WorkShop
Creating a Recorded Application
Examining the Data
Recording a Summation Macro
Recording an Averaging Macro
Recording the Maximum Macro
Recording the Minimum Macro
Recording Divisional Macros
Testing Macros
Creating Objects to Run Macros
Assigning a Macro to an Object

User-Defined Functions
User Defined Function Overview
Creating a User Defined Function
Using a User Defined Function
Creating Another Function
Passing Multiple Arguments
Modifying a Function
Creating a Function Library

Using the VBA Editor
Overview of the VBA Editor
Opening And Closing the Editor
Working with the Project Explorer
Working with the Properties Window
Using the Work Area
Working with a Code Module
Running Procedures from the Editor
Setting Break Points in the Editor
Stepping Through a Procedure

Understanding VBA
Using the Immediate Window
Working with Object Collections
Setting Property Values
Working with Worksheets
Using the Object Browser
Programming with the Object Browser

Procedures
Creating a Command Procedure
Making Sense of IntelliSense
Using the Edit Toolbar
Commenting Statements
Indenting Text
Bookmarking in Procedures

Using Variables
Overview of Variables
Creating And Using Variables
Implicit And Explicit Declarations
The Scope of Variables
Procedure Level Scoping
Module Level Scoping
Public Scoping of Variables
Passing Variables By Reference
Passing Variables By Value
Avoiding Variant Data Types
Using Arrays

Using Excel Objects
Splitting the Screen
Using Workbook Objects
Using Worksheet Objects
Using Range Objects
Using Objects in a Procedure

Programming Techniques
Understanding Programming Conventions
Communicating with the User
Prompting for User Input
Using the Input Method
Using IF to Make Decisions
Testing for Multiple Conditions
Looping a Fixed Number of Times
Looping a Specified Number of Times
Looping an Unknown Number of Times

Creating Custom Forms
Creating a Custom Form
Changing the Form Properties
Adding Text Boxes to the Form
Moving Controls
Adding Label Controls to the Form
Changing Text Box Control Properties
Changing Label Control Properties
Adding a Combo Box
Adding Option Buttons
Adding Command Buttons
Running a Form

Programming Custom Forms
Initialising the Form
Closing the Form
Updating the List
Creating Error Checking Procedures
Running a Form from a Procedure

Custom Menus
Overview of Custom Menus
Creating a New Menu
Creating a Cascade Menu
Adding Menu Commands
Assigning Macros to Menu Commands
Removing a Menu

Automatic Startup
Overview of Automatic Startup
Programming Automatic Events
Running Automatic Procedures
Automatically Starting the Workbook