Tools
You are here: Home » Training Courses » Microsoft » Excel » Excel 2007
Monday, 09 Dec 2024

Microsoft Excel 2007 - VBA

Course Objectives

This one day course gives an overview of Excel’s programming language (VBA). The course will introduce the Visual Basic Editor screen (VBE), discuss the major programming concepts, cover error checking tools and enable users, through a workshop, to try out practical examples.

Who Should Attend?

Those who have advanced knowledge of Excel 2007 and who would like a broad overview of Excel's macro language. The course does not assume previous experience of macros although it would help if delegates have recorded some macros in the past. Delegates who do not have this level of knowledge of Excel should first attend our "Microsoft Office Excel 2007 Advanced" course.

Course Contents

Using the Visual Basic Editor

  • Object Properties
  • Methods
  • Events
  • The Object Browser

Data Types

  • Declaring Variables
  • The scope of variables

Procedures

Modules

Functions

  • Creating a user defined function

Branches

  • Using If and Else
  • Using Select Case

Loops

  • For/Next
  • Do While/Loop

User Interaction

  • Message Boxes
  • InputBox function
  • Creating a User Form
  • Attaching events to User Form buttons

Error Handling

  • Understanding different types of errors
  • VBA debugging tools
  • Breakpoints and Watch windows
  • Stepping through code
  • Handling errors

Workshop

  • Using examples to practice VBA techniques
  • Option for users to create macros of their own choice

Microsoft Excel 2007 Course DetailsDownload Course Details

(Page 5 of 5)

Contact Us

Telephone : 0117 929 1509
Send us a message or request a call back

1000 characters left

Microsoft Excel 2007 Courses

There are no courses scheduled