VBA for Excel training course

VBA For Excel Training - 2 days - £450 + vat - dates

Excel VBA training uk

This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications - concentrating on Microsoft Excel. During this VBA for Excel Training Course students will learn to create and edit macros, and gain an understanding of VBA code.

The Visual Basic for Applications content of the training course can be applied to other Microsoft Applications.

Excel with VBA Training Course Content

Creating Record Macros

  • Recording a Macro
  • Running a Macro
  • Running a Macro from the Macros Dialog Box
  • Creating a Short-cut key to run a macro
  • Running a Macro with a Shortcut key
  • Assigning a Macro to a Menu or Toolbar
  • Editing a Macro with Visual Basic

Visual Basic Editor

  • Objects
  • Methods
  • Properties
  • Programming Tools
  • The Menu Bar

Running Code

  • Run mode and Design mode
  • Running Code from the development environment
  • Running Code from the host application

The Project Explorer

  • Using the Project Explorer

The Properties Window

  • Changing a Property

Using Constants

  • Excel Constants
  • Variable Constants

Excel Objects

  • Objects, Properties and Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections of Objects

Variables

  • Dimensioning a variable
  • Using variables in routines
  • Object Variables

Using Visual Basic Functions

  • InputBox Function
  • MsgBox Function
  • Using a Set Statement

Building Formulae Control Structures

  • If…Then Decision Structures
  • Logical Operators
  • Select Case Decision Structures
  • Case Else
  • Comparison Operators with Select Case Structure
  • For… Loops
  • Do Loops
  • While...Wend Statement

UserForms

  • Designing & Creating Forms
  • Working with Controls
  • Creating Custom Dialog Boxes
  • Userform Properties Methods & Events

Event Handling

  • VBA Editing & Debugging
  • Auto Macros
  • Error Handling

Excel with VBA Course Prerequisites

Delegates should have attended the Advanced Excel Course and have a good understanding of Excel functions and Templates.

Excel with VBA Training Recommended Reading

Excel 2002 Power Programing with VBA - John Walkenbach – buy from amazon
Excell 2002 VBA Programmers Reference - S Bullen – buy from amazon
Microsoft Office Excel 2003 – buy from amazon

home   book this course   resources   01273 622272 info@siliconbeachtraining.co.uk

Microsoft, Sage and Business Applications Courses UK

Up

Microsoft Office and Sage Accounts are skills needed in most modern businesses, we offer a full range of beginners courses, and for more advanced delegates we provide VBA for Access and VBA for Excel training courses.

Microsoft and Business Applications UK

Up