Visual Basic for Excel 97

For experienced Excel users who want to make use of the more powerful facilities of the package made available by VBA. This course explores the VBA language and delegates will be encouraged to write programmes to ensure that future editing, amending and updating can be carried out with the minimum of effort.

Level of the course: Third
Duration: 2 days
Hours: 9.30am - 4.30pm

A certificate will be issued to each delegate and will contribute to units of the appropriate NVQ.

Topics Covered:-

What is a Macro?
Recording and running a Macro
Relative references
Assigning Macros to buttons

Objects:-
Assigning a Macro to a button or a drawn object on a sheet
Assigning a Macro to a button on a toolbar
Customising a toolbar
Creating a toolbar
Button image editor

Editing Macros:-
Visual Basic Editor
The project explorer
Procedures
Inserting comments
Printing a visual basic module

The Range Object:-
The cells and range Property
Flexible ranges
Range contents

Wordbooks and Sheets:-
Activating a workbook and worksheet
This workbook

Objects, Properties & Methods:-
Controlling objects with their properties
Performing actions with methods
Performing multiple actions on an object

Variables & constants:-
Variables, data types and constraints

Control Structures:-
Conditional and looping control structures
Non-Structured Statements
Sub procedures

Controls dialogue boxes and forms:-
Built-in and predefined dialogue boxes
Custom, worksheet and user defined forms
Adding control forms
Control and dialogue box events
Displaying and dismissing a user form
Handling form controls

Storing Information:-
The Windows Registry: setting files
WritePrivateProfileString
Toolbars and Display
About toolbars and menus
Customised toolbars
Display

Debugging and error Trapping:-
Errors,breakmode instant watch
Stepping and error handling
Worksheet and workbook events
Worksheet object events
workbook object events

Function Procedures:-
User defined functions

Add-in Applications:-
Creating an Add-in
Appendix-User form controls, Memory Variables

Issue: 14/3/02
Course Code: VBAEXCEL