Excel VBA Intermediate

Course

Inhouse

£ 1,071 + VAT

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    2 Days

  • Start date

    Different dates available

Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel's Visual Basic Editor.

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open

About this course

Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel's Visual Basic Editor.

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
  • Property
  • Visual Basic
  • MS Excel
  • Excel on-site training
  • Excel in-house training
  • Excel training

Course programme

Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel's Visual Basic Editor.

Course Outline

Excel object model

About classes and objects, Objects and collections, The hierarchy of objects, Properties, methods and events, The Locals Window, The Immediate Window

Function procedures

Sub versus function, User-defined functions, Declaring a function, Calling a function, Private and public scope, Defining arguments, Optional arguments

The Application object

When to use, ScreenUpdating property, DisplayAlerts property, Setting CutCopyMode to false

Dialogue boxes

MsgBox function, InputBox function, Application.Dialogs

UserForms

Creating a userform, Displaying a userform, Adding Label controls, Adding a TextBox control, The CheckBox control, The OptionBox control, ComboBox and ListBox, SpinButton controls, Adding CommandButtons, Setting control properties

Workbooks and worksheets

The Workbooks collection, The Sheets collections, The Window objects, Workbook events

Ranges and names

Column and Row properties, CurrentRegion property, The Union method, The Intersect method, Using the Name property, Working with named ranges

Pivot tables

Pivot table code overview, Creating a pivot table, PivotField object, PivotItems collection, Modifying a pivot table, Using external data

Charts and drawings

About programming charts, Working with embedded charts, Working with independent charts, Controlling chart formatting, Assigning a range to a chart, Positioning a chart, Making a chart active/inactive, Editing data series, Controlling chart labels, Drawing shapes, Setting shape attributes

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 Intermediate

£ 1,071 + VAT