Aston Recruitment and Training offer well-resourced apprenticeships, learning programmes and courses. Which include Engineering, Leadership and Management, Sales, marketing, health, hairdressing and a whole host of others. Whether it’s short or long term development Aston can help

aston apprenticeships

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)


Ending a macro

We use cookies on our site by continuing to browse our site, you agree to the use of these cookies.
You can read our cookie policy and learn more here