Microsoft Excel Level 5 VBA Programming Introduction

WWP Training Limited
Delivery Method: Face-to-face
Microsoft Excel Level 5 VBA Programming Introduction

 Course Aims:

This course is aimed at people who wish to make a start at learning the Excel VBA programming language, familiarising themselves with the concepts and practice of VBA programming, and understanding and using the relevant techniques.

Course Pre-requisites:

Students who wish to attend this course need to have significant experience and ability at understanding and using Excel advanced functionality. This programme is quite demanding and requires a high level of commitment from participants.

Course Objectives:

On completion of this course delegates will be able to:

  • Use the Macro Recorder
  • Understand how VBA code is stored and how to access it using the Visual Basic Editor
  • Launch the Visual Basic Editor and use it to manage module sheets and code
  • Get macros to run via shortcut keys, menus and buttons
  • Write simple sub procedures with frequently used Excel objects, methods and properties
  • Create decision-making code
  • Use the Do and While loop to repeat the execution of code
  • Use simple variables to store and return information in a sub procedure


Course Content:

Introduction and Objectives

 Recording Macros

  • What is a macro?
  • Recording a Macro
  • Running a Macro
  • Saving a Workbook Containing a Macro
  • Opening a Workbook Containing a Macro
  • Saving the Personal Macro Workbook


The Visual Basic Editor

  • Launching the Visual Basic Editor
  • Navigating the Visual Basic Editor
  • Finding a Macro in the Visual Basic Editor
  • Inserting a Module into a Workbook
  • Copying a Module between Workbooks
  • Renaming a Module Sheet
  • Deleting a Module Sheet


Assigning Macros

  • Running a Macro with Shortcut Keys
  • Adding Custom Buttons to Run a Macro
  • Removing Custom Buttons
  • Creating and Editing a Worksheet Macro Button


Writing Procedures

  • Frequently Used Excel Objects (Range, WorkSheets, WorkBooks)
  • Methods and Properties
  • Adding Arguments to Methods
  • Selection or ActiveCell?
  • The With ... End With Block
  • The Offset Property
  • Dealing with a Runtime Error


Control Structures

  • The If - Then Control Structure
  • The If – Then - Else Control Structure
  • Using ElseIf in a Control Structure
  • The Select Case Control Structure
  • Using a Do - Loop Statement


Data Variables

  • What are Data Variables?
  • Creating Data Variables and Assigning Values


Action planning

Review of Programme


Related Courses

Excel Level 6 VBA

Dates available on arrangement

WWP Training Limited can also create this course for you on arrangement either at your workplace or at one of their locations.

Make Enquiry

Write A Review Of Microsoft Excel Level 5 VBA Programming Introduction

£456.00 (inc VAT)
Make Enquiry Add To Wishlist
All prices include VAT where applicable