Excel 2003 VBA Basic

Raising the Bar
Sydney, NSW, Australia

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

Course Description:

'' Recording Macros
Record Absolute and Relative Macros
Assign Marcos to a Button

User Defined Functions
Create a Custom Function to Perform a Calculation
Call a Function from a Worksheet
Call a Function from a Macro

Using Visual Basic Editor
Visual Basic for Applications
Working with Objects, Properties, Methods, and Events
Use the Immediate window
Understand the Object Model
Using the Object Browser

Programming basics
Working with data
Using Variables
Understanding Scope
Controlling program flow
Using Decision Structures
Using Loop Structures and their Variations

Working with custom dialog boxes
Creating custom dialog boxes (Userforms)
Handling events
Programming Custom Dialog Boxes

Automatic Startup
Create a Macro to Run Automatically on Start up

Custom Menus
Create a Custom Menu for a Project
Customise the Menu System

Debugging and error-handling
Errors in Code
Using Debugging Techniques
Error-handling
...''

Phone:(02) 9929-8845

School Address:

Suite 501, Level 5
65 Walker St
North Sydney NSW 2060


Jobs & Resumes: Sydney
Houses & Roommates: Sydney
Travel Agencies: Sydney

Search other schools for Excel 2003 VBA Basic training resources.

Access 2003 VBA Basic
Access 2003 Basic
Access 2003 Intermediate
Access 2003 Advanced
Excel 2003 Advanced
Excel 2003 Intermediate
Excel 2003 Basic
Outlook 2003 Basic
Outlook 2003 Advanced
Powerpoint 2003 Advanced
Powerpoint 2003 Basic
Project 2003 Advanced

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.