Microsoft Excel VBA Stage 2

Microsoft Excel VBA Stage 2

Duration:
1 Day
Aims:

This course is designed for those who wish to further develop their understanding of VBA gained from attending our Stage 1 course.

Objectives:

On completion of this course, attendees will be gain the confidence to write procedures to develop efficient and practical VBA solutions. They will understand the importance of and learn how to manipulate the Range object and create procedures which automate repetitive tasks. They will also learn how to write and use Function procedures.

Pre-Requistites

This course is the second day of the introduction to programming in VBA. As such you should have attended stage 1. Before attending this module we would advise you to revise the course materials from stage 1.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Loops
  • - The concept of looping
  • - Different types of loop
  • - For - Next Loop
  • - Do - Loop
  • - For Each Loop
Collections and Object Hierarchy
  • - A closer look at how objects are organised
Exploring the Range Object
  • - Referring to a Range
  • - Collections and Items
  • - The CurrentRegion Property
  • - The Offset & Resize Properties
Calling Sub Procedures
  • - Defining arguments in called procedures
User Defined Functions
  • - Using Excel Worksheet Functions in VBA
  • - VBA Functions
  • - User-Defined Functions
  • - Declaring Variables in User Defined Functions
  • - Using Ranges in User Defined Functions
Writing Macros
VBA Terminology
  • - Procedures, Subroutines, Macros, Functions
  • - Objects, Methods, Properties
Further Testing and Debugging Techniques
  • - Types of Error and Debugging
  • - Stepping Through a Procedure
  • - Monitoring Variable Values
  • - Break Mode
  • - Testing and Debugging Code
  • - Watch & Immediate Window
Related courses
Run this
course at
your offices
Request a quote
which course
Which level do you need?
Take our online skills assessment
Find out more
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot