The skills participants will develop:

At the end of this course delegates will be able to

Understand VBA code

Examine sample code

Create macros from scratch, and amend existing macros

Course content will include:

An introduction to Excel Visual Basic

Running a macro

Recording a macro

Modules

Personal Macro workbooks

Assigning macros

Absolute and relative macros / Assigning shortcut keys to macros / Assigning macros to buttons on the sheet / Assigning macros to menus / Assigning a macro to a button on a toolbar

Decision making code

If .....Then control structures / If .....Then ....Else control structures / Using Select case

Using loop structures

For..... Next statement / Do ..... Loop statement / Using For Each ...... Next statements

Objects & Variables

Using variables / Understanding variable types / Objects, methods & properties

Interactive macros

Creating custom message boxes

Creating custom input boxes

The intermediate course will cover the above plus the additional content shown below:

Debugging & Error Trapping

Error Trapping, Stepping

Break Mode

Instant Watch, Immediate Window

Objects & Variables

Declaring & using variables & arrays

Scope & visibility

Defining Constants

Interactive Macros

Userforms, controls & dialog boxes

Creating & displaying userforms& control properties

Active X

Overview of Active X

DURATION 1 Day