Any Square One course can be tailored to meet the particular requirements of your organisation.
We will be happy to use any of your examples for delegates to ensure that the course is as interesting and relevant as possible.

Pre-requisites: No programming knowledge assumed, some experience of MS Excel (i.e. basic spreadsheet theory) is essential.

Duration: 2 days
Timings: 9:30 - 16:30

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course.

Booking

Microsoft Excel Macros/VBA

Outline

What is a Macro
Recording & Running a Macro
Relative References

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
Changing a Button’s Screen Tip

Visual Basic Editor
Project Explorer
Procedures, Inserting Comments
Printing a Visual Basic Module

Cells & Range Method; Flexible Ranges
Virtual Worksheets; Range Contents

Activating a Workbook & Worksheet
This Workbook

Controlling Objects with their Properties
Performing Actions with Methods
Performing Multiple Actions on an Object

Variables, Data Types & Constants

Conditional & Looping Control Structures
Non-Structured Statements
Sub Procedures

Built-In & Predefined Dialogue Boxes
Custom, Worksheet & User Defined Forms
Adding Form Controls
Form Control Properties
Control & Dialogue Box Events
Displaying & Dismissing a User Form

The Windows Registry

About Toolbars & Menus
Customised Menus
Display

Errors, Break Mode; Instant Watch
Stepping & Error Handling

Worksheet Object Events
Workbook Object Events

User Defined Functions