We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields
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

 

 

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 23 Feb 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields