Excel VBA Introduction

Course

Inhouse

£ 1,071 + VAT

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    2 Days

  • Start date

    Different dates available

Overview Our Excel VBA level 1 course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment.

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open

About this course

Overview Our Excel VBA level 1 course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Basic
  • Visual Basic training
  • IT
  • Basic IT training
  • Basic IT
  • Visual Basic
  • MS Excel
  • Excel on-site training
  • Excel in-house training
  • Excel training

Course programme

Overview Our Excel VBA level 1 course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment.

Basics Excel VBA overview, Understanding macro steps, Modifying macro steps, Calling one macro from another, Storing values in variables, Adding comments to your code, Stepping through macros, Getting help on macros, Objects, properties and methods, About Excel objects, Using the Object Browser Range object The Selection property, The Range property, Targetting cells, Counting the cells in a selection, Using the Offset statement, Retrieving the value of a cell, Retrieving a formula from a cell, Setting the value of cells Charts and drawing About programming charts, Assigning a range to a chart, Positioning a chart, Drawing shapes, Setting shape attributes Using Visual Basic Language structure, Using variables, Declaring variables, Scoping variables, Data types, Using constants, Using the VBA debugger, Making decisions, If statements, Select Case, Looping structures, Different types of loops, Manipulating arrays Interactivity Assigning a macro to a menu, Assigning a macro to a toolbar, Assigning macros to other objects, Built-in dialogue boxes, Creating custom forms, Using the Form Editor , Using form controls

Additional information

£900 for one-to-one training

£1,100 for groups of up to 6 people

£1,300 for groups of up to 12 people

Excel VBA Introduction

£ 1,071 + VAT