Jayne Wilkins & Associates Training Courses In Kent In London

01303 268357

jayne@jaynewilkins.co.uk

Microsoft Excel Courses - VBA Foundation

Microsoft Excel Courses

Microsoft Excel VBA - Foundation/Introductory Course

This very popular Microsoft Excel VBA (Visual Basic for Applications) Foundation/Introductory course is a two day course aimed at advanced Excel users.  Students attending this course should have already completed the Excel Intermediate and Advanced courses or alternatively have a very good working knowledge of Excel. 

This two day Excel VBA course demystifies the Excel VBA language.  The course starts from recording macros from the Excel worksheet and then goes onto show how to write code in the VBA window.  This course is a must for any advanced Excel user who records macros on a regular basis.

From: £POA
Level: VBA Foundation
Duration: 2 Days

What is a Macro

  • Recording a Macro
  • Running a Macro
  • Relative references
  • The Developer Ribbon Tab

Assigning Macros to Buttons and Objects

  • Adding a Macro Ribbon Tab
  • Assigning Macros to sheet buttons
  • Assigning Macros to toolbar icons

Editing Macros

  • Editing a Macro
  • Procedures
  • Inserting comments
  • Printing a VBA Module

The Range Object

  • Cells method
  • Range method
  • Flexible ranges
  • Virtual worksheets
  • Range contents

Objects Properties & Methods

  • Controlling objects with properties
  • Performing actions with methods
  • Performing multiple actions

Variables and Constants

  • Variables
  • Data Types
  • Constants

Control Structures

  • Conditional Control Structures
  • Looping Control Structures
  • Non-structured statements
  • Sub Procedures

Controls & User forms

  • Built-in dialogue boxes
  • Predefined dialogue boxes
  • Controls
  • Custom dialogue boxes
  • Assigning procedures to a dialogue box

Menus & Toolbars

  • Customised menus
  • Managing menus
  • Ribbons Tabs and Tooltips

Testing & Debugging

  • Types of errors
  • Break mode
  • Instant watch
  • Stepping

Event Triggered procedures

  • Creating automatic procedures
  • Creating event procedures

Function Procedures

Add-in Applications