Excel - Programming in VBA 2000/2002

Drake Training
Adelaide, Brisbane, Canberra, Melbourne, Perth, Sydney, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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
...''

Phone:1300 362 262

School Address:

Level 40, 55 Collins Street
Melbourne VIC 3000, Australia



Jobs & Resumes: Adelaide, Brisbane, Canberra, Melbourne, Perth, Sydney
Houses & Roommates: Adelaide, Brisbane, Canberra, Melbourne, Perth, Sydney

Influencing and Negotiating
Lead, Manage and Develop Teams
Train the Trainer
Access - Programming in VBA 2000/2002
Access Level 1
Access Level 2
Acrobat
Illustrator
InDesign
Photoshop
Microsoft Excel Level 1
Microsoft Excel Level 2
Microsoft Excel Level 3
FrontPage
Outlook 2003
PowerPoint Level 1
PowerPoint Level 2
Project 2003
Microsoft Visio 2003

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.