Visual Basic is engineered for productively building type-safe and object-oriented applications. Visual Basic enables developers to target Windows, Web, and mobile devices. As with all languages targeting the Microsoft .NET Framework, programs written in Visual Basic benefit from security and language interoperability.

Target audience:          Experienced users of Excel who have attended Excel level 3 training

Duration                          1 Day

Objectives                       For users wishing to automate Excel procedures by writing macros and gain a rudimentary understanding of Visual Basic.

Course content:

• Recording Macros and Running Macros

Editing a macro

Avoiding errors

Worksheet buttons

Toolbar buttons

• General Macros

Global macros using the Personal Macro Workbook

Absolute v Relative cell Addressing

• More Complex Macros

Using the VB Toolbar

Debugging macros using Step

Introduction to common VB statements

• Repetitive Tasks within Macros

Making decisions (IF)

Loops

Ending a macro