Microsoft Excel VBA Programming (Level 4) 2007 2010 2013 2016 & 365

Training

In Sunderland

£ 495 VAT exempt

Description

  • Type

    Training

  • Level

    Advanced

  • Location

    Sunderland

  • Duration

    2 Days

  • Start date

    Different dates available

Become fully proficient with Microsoft VBA Programming.
Individuals will be able to make use of the most powerful features of Microsoft Excel available through programming VBA code. Some of topics covered include macros, writing/editing code, variables, objects, properties and methods, control structures and debugging tools.

Important information

Documents

  • Course content

Facilities

Location

Start date

Sunderland (Tyne and Wear)
See map
Tthe Quadrus Centre, Woodstock Way, Boldon, NE35 9PF

Start date

Different dates availableEnrolment now open

About this course

The course is mainly aimed at individuals who have a good knowledge of Microsoft Excel including commands, functions and simple macros.

Experience of Microsoft Excel including commands, functions and basic macros is required for this course.

Certificate of participation can be obtained if required.

On receiving your request we will contact you to explain course content, including course dates and payment options.

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

  • Microsoft Excel
  • Programming
  • Microsoft excel training
  • MS Excel
  • VBA (Microsoft Access / Office)
  • Macros
  • Excel Objects
  • Excel Functions
  • Debugging
  • Excel Variables

Teachers and trainers (2)

Chris Edmondson

Chris Edmondson

IT Trainer

Paul Robson

Paul Robson

IT Trainer

Course programme

VBA Programming in Excel

The topics covered are as follows:

1 Introduction to Macros
· What is a Macro?
· Recording a Macro
· Running a Macro

2 Editing Macros
· The Visual Basic Editor
· The Project Explorer
· The Code Window
· Procedures
· Comments
· Printing a Module

3 The Range Object
· What is the Range Object
· The Cells Property
· The Range Property
· Range Contents

4 Workbooks and Sheets
· Activating a Workbook
· Activating a Worksheet
· This Workbook

5 Objects, Properties and Methods
· Controlling objects with Properties
· Performing Actions with Methods
· Performing Multiple Actions on an Object

6 Variables and Constants Control Structures
· Conditional Control Structures
· Looping Control Structures
· Non-Structured Statements
· Sub Procedures

7 Controls, Dialog Boxes and Forms
· Dialog Boxes
· Custom Forms
· Worksheet Forms
· Setting Properties of a Control
· Adding Controls
· Control and Dialog box Events

8 Storing Information
· The Registry
· Settings Files

9 Using Toolbars
· Toolbars and Menus
· Attaching Toolbars to Workbooks
· Customising Toolbars

10 Debugging and Error Trapping
· Types of Error
· Break Mode
· Instant Watch
· Stepping Through Code
· Error Handling

11 Function Procedures
· Function Procedures
· User Defined Functions
· Function Wizard
· Excel Functions

12 Add-In Applications
· What is an Add-in?
· Creating an Add-In
· Converting an Add-In to a Workbook

Microsoft Excel VBA Programming (Level 4) 2007 2010 2013 2016 & 365

£ 495 VAT exempt