Excel VBA 2000/XP/2003

Duration 2 days

Course Content

Simple Macros

Recording a Macro
Running a Macro
Using the Visual Basic Toolbar
Making Macros Easier to Use
Adding to the Tools Menu
Assigning to a Button on a Sheet
Assigning to a Toolbar Button
Assigning to a Graphic Object
Macro Storage
Relative & Absolute References

Viewing & Modifying Visual Basic Code

Module Sheets
Reading Visual Basic Code
Statements
Comments
Rem Statements
Keywords
Keystrokes used in a Module Sheet
Editing Code
Deleting Unnecessary Code
Making Long Statements Readable
Customising Code
Making a Macro Interactive
Recording Code into an Existing Macro

Making Macros Make Decisions

Control Structures (Decision Making)
If...Then
If...Then...Else
Control Structures (Looping)
Do Loop

Objects

Object Properties
Common Properties
Object Methods
Toggling the Property of an Object

On-Sheet Controls

Placing Controls on the Worksheet
Setting the Properties of a Control
Linking Controls to Worksheets

Qualifications
for team leaders
and first line
managers

ILM Endorsement refers to bespoke programmes that have some form of assessment and are approved as ILM Endorsed Awards. Call or contact Adapt to discuss your specific requirements

Looking for a bespoke programme which has been approved by ILM but doesn’t have an assessment process? Choose Adapt to design a programme for an ILM Development Award

What they said about ...

ILM Level 3 Award in First Line Management

Jane is an excellent trainer and explained everything very clearly, excellent course with content well explained

The trainer answered all my questions superbly, very comprehensive on the detail of the course

Very knowledgeable and helpful and understanding and re explaining

Very good course which has taught me how to talk and deal with my team

Kept interesting and fresh throughout. Easy to stay attentive