IT Computer Training Courses Edinburgh, Glasgow, Scotland: Microsoft Excel VBA Computer Training: iTrain Scotland: Microsoft Office 2016 Training, Adobe Training, Windows 10 training, Office 2013 training, Computer Courses, Computer training room equipment hire

Classroom with tutor
or
Live virtual classroom

1 Day

Training Options:

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Classroom with tutor
or
Live virtual classroom

1 Day

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Microsoft Excel VBA

Whether you are a new user or have been using Excel VBA for years, this course will vastly increase your understanding of Excel VBA. Existing users will learn how to get the most out of Excel VBA, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Excel VBA trainers.

Course content

Prerequisites

This course has been designed for advanced users of Microsoft Excel who are looking to develop macros and learn how to code with VBA.

Course goals

Delegates will learn how to code using VBA. Delegates will also learn shortcuts and tips about how to use Excel VBA in the most efficient way.

Topics

Introduction to Macros

What is a Macro?
Recording a Macro
Running a Macro
Relative References
Assigning a Macro to a Button on a Worksheet
Assigning a Macro to a Button on a Toolbar
Button Image Editor

Editing Macros

The Visual Basic Editor
The Project Explorer
The Code Window
Procedures
Inserting Comments
Printing a Visual Basic Module

The Range Object

What is the Range Object?
The Cells Property
The Range Property
Flexible Ranges
Range Contents

Workbooks and Sheets

Activating a Workbook
Activating a Worksheet
ThisWorkBook

Debugging and Error Trapping

What are Errors?
Types of Error
Break Mode
Instant Watch
Stepping Through Code
Error Handling Worksheet and Workbook Events

Objects, Properties and Methods

Controlling Objects with their Properties
Performing Actions with Methods
Performing Multiple Actions on an Object

Variables and Constants Control Structures

Conditional Control Structures
Looping Control Structures
Non-Structured Statements
Subprocedures

Controls, Dialogue Boxes and Forms

Built-In Dialogue Boxes
Predefined Dialogue Boxes
Custom Forms
Worksheet Forms
Setting the Properties of a Control
User-Defined Forms
Adding Form Controls
Form Control Properties
Control and Dialogue Box Events
Displaying and Dismissing a User Form
Handling Form Controls

Toolbars and Display

About Toolbars and Menus
Attaching Toolbars to Workbooks
Saving More Than One Toolbar Configuration
Customising Toolbars
Display Techniques

Function Procedures

Function Procedures
User-Defined Functions
Function Wizard
Excel Functions

Add-in Applications

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

Prices

Prices below are for scheduled courses held in our Edinburgh Training Centre or Live Virtual Classroom. Major discounts available for onsite or private courses: click General Enquiry button below to enquire about private courses.

Group discount

1 place £ 355 n/a

2 places £ 710 n/a

3 places £ 1065 £ 969

4 places £ 1420 £ 1278

5 places £ 1775 £ 1580

6 places £ 2130 £ 1874

7 places £ 2485 £ 2162

8 places £ 2840 £ 2442

		Group discount
1 place	£ 355	n/a
2 places	£ 710	n/a
3 places	£ 1065	£ 969
4 places	£ 1420	£ 1278
5 places	£ 1775	£ 1580
6 places	£ 2130	£ 1874
7 places	£ 2485	£ 2162
8 places	£ 2840	£ 2442