Microsoft Excel 97 VBA Training Course in London and the UK

Our Excel VBA course help you create automated spreadsheets for all those repetitive tasks. VBA can also help to simply complex tasks that needs to be performed on a regular basis. At the end of the course, users will be able to record and ruin macros, edit the VBA code, build in looping structures and create custom forms. We also cover error handling and event procedures.

Excel 97 VBA Macros Training Course Information

Audience: This course is aimed at experienced Excel users who need to automate repetitive tasks or simplify more complex tasks using macros and VBA.

Course Duration: This is a 2 day Excel 97 VBA Course. Course starts at 09:30 and runs until 16:30

Excel 97 VBA Course Objectives: After the course, you will be able to:

Record / Run Macros
Write Code Manually
Perform Loops, Controls and Error Handling
Create UDF Functions and Add-ins
Create User forms and Sheet Controls
Use Events

Requirements: You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our advanced course level.

Course Locations / Schedule

This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Excel 97 VBA Macros Training Course Contents

Concept, Recording and Running Macros, the VBE Environment

The Project Window
Code Window
Properties Window
Navigating between Excel and the VB Editor

Editing Code + Methods of Executing

Using the Visual Basic Editor
Structure of a sub routine
Key Words
Navigation in a Module
Editing in a module
Use of Function Keys
Run subroutines together
Menu, Visual Basic Toolbar, Keyboard Shortcut, Custom Toolbar Button, Custom Menu Item, Forms Toolbar executing

Visual Basic Language Rules