VBA Essentials using Excel training courses in and around Newcastle and the North East. VBA Essentials using Excel courses in Durham, Washington, Sunderland, Darlington, Middlesbrough, Gateshead, Leeds and throughout North East England.

Course VBA Essentials using Excel

Public Scheduled Price£495 +VAT
Course Duration2 Days
Course Options
Public Scheduled

Public Scheduled
Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!

Private

Private
Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.

Bespoke

Bespoke
Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.

Overview

This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.

Prerequisites

- Delegates should have attended the Excel level 3 course or have equivalent knowledge. Previous use of macros would be an advantage, but is not essential.

Objectives

- Go beyond the user interface of Excel into the Visual Basic for Applications component. This will allow delegates to be able to write/modify programs using Visual Basic for Applications. Delegates will be able to :
- Control and manipulate Excel using Visual Basic Code
- Create forms to enter data directly onto your spreadsheet
- Write complicated macros to check spreadsheet data
- Create functions that will perform complex calculations

What's included

- Laptops are available for training delivered at client's premises
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
- Telephone and Email Support

Course Content

- Getting Started
  Introducing Visual Basic for Applications
  Recording a Macro
  Running a Macro
  Editing a Macro in the Visual Basic Editor
  Understanding the Development Environment
  Using Visual Basic Help
  Closing the Visual Basic Editor
- Working with Procedures and Functions
  Understanding Modules
  Creating a Standard Module
  Understanding Procedures
  Creating a Sub Procedure
  Calling Procedures
  Using the Immediate Window to Call Procedures
  Creating a Function Procedure
  Naming Procedures
  Working with the Code Editor
- Understanding Objects
  Navigating the Excel Object Hierarchy
  Understanding Collections
  Using the Object Browser
  Working with Properties
  Using the With Statement
  Working with Methods
  Creating an Event Procedure
- Using Expressions, Variables, and Intrinsic Functions
  Understanding Expressions and Statements
  Declaring Variables
  Understanding Data Types
  Working with Variable Scope
  Using Intrinsic Functions
  Understanding Constants
  Using Intrinsic Constants
  Using Message Boxes
  Using Input Boxes
  Declaring and Using Object Variables
- Controlling Program Execution
  Understanding Control-of-Flow Structures
  Working with Boolean Expressions
  Using the If...End If Decision Structures
  Using the Select Case...End Select Structure
  Using the Do...Loop Structure
  Using the For...Next Structure
  Using the For Each...Next Structure
  Guidelines for use of Control-of-Flow Structures
- Working with Forms and Controls
  Understanding UserForms
  Using the Toolbox
  Working with UserForm Properties, Events, and Methods
  Understanding Controls
  Setting Control Properties in the Properties Window
  Working with the Label Control
  Working with: Text Box Control. Command Button Control, Combo Box Control, Frame Control and Option Button Controls
  Working with Control Appearance
  Setting the Tab Order
  Populating a Control
  Adding Code to Controls
  Launching a Form in Code
- Debugging Code
  Understanding Errors
  Using Debugging Tools
  Setting Breakpoints
  Stepping through Code
  Using Break Mode during Run mode
  Determining the Value of Expressions
- Handling Errors
  Understanding Error Handling
  Understanding VBA's Error Trapping Options
  Trapping Errors with the On Error Statement
  Understanding the Err Object
  Writing an Error-Handling Routine
  Working with Inline Error Handling

Course Dates

Related Courses

- VBA Essentials using Access
  
  This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access applicat
- VBA using Word
  
  This course is designed to help experienced Word users automate common tasks and create end user systems. The user does

Other Courses In This Series

Contact us online or call us on 0191 377 8377

Contact us