Microsoft Excel VBA Introduction Training course Outline (2 day)

Audience: This course is aimed at experienced Excel users who need to automate repetitive tasks or simplify more complex tasks using VBA macros. Learn the elements of the Excel object model and control their automation using simple VBA control structures. Discover different ways of running macros and master the Dim statement. And save huge amounts of time every day.

Course Duration: 2 days

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel VBA introduction training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

.At Course Completion

After completing this course, students will be able to:

  • Use the macro recorder
  • Understand the Visual Basic Editor
  • Develop Procedures
  • Manage the Flow of Control using control structure
  • Debug procedures
  • Understand the Excel Object Model
  • Declare and set the data type of variables
  • Create User Defined Functions
  • Write Error Handling routines
  • Use Message Boxes and Input Boxes

Course Outline

Module 1: Recording Macros

  • Recording and running macros
  • Recording Absolute and Relative selection
  • • Saving a macro-enabled workbook
  • • Assigning a macro to the QAT
  • • Creating a Macro Button
  • • Using the Personal Macro Workbook

Module 2: Working with the Visual Basic Editor

  • Introducing Visual Basic for Applications
  • Navigating the Visual Basic Editor
  • Using Help
  • Using statement completion
  • Memory variables

Module 3: Developing Procedures

  • Understanding and creating modules
  • Defining procedures
  • Calling subroutines

Module 4: Managing the Flow of Control

  • Defining control structures
  • Decision making structures
  • If…End If structure
  • Select Case…End Select structure
  • Looping structures
  • Conditional loops: the Do…Loop structure
  • Counter loops: the For…Next structure
  • Collection loops: the For Each…Next structure

Module 5: Debugging

  • Stepping through code
  • Setting Breakpoints
  • Break mode
  • Identifying the current value of expressions
  • Using the Immediate Window

Module 6: Introducing Objects

  • The Excel Document Object Model
  • Objects and Collections
  • The Object Browser
  • Methods and Properties
  • The With statement

Module 7: Declaring Variables

  • How to declare variables
  • Defining the Scope and Lifetime of variables
  • Determining Data Types
  • Defining constants and using intrinsic constants
  • How to declare and use Object variables

Module 8: Creating User Defined Functions

  • Calling Excel worksheet functions
  • Creating a function procedure
  • Calling a User Defined Function
  • Using multiple and optional arguments

Module 9: Error Handling

  • Defining error handling
  • VBA’s error trapping options
  • Capturing errors with On Error statements
  • The Error object
  • Coding an error handling routine

Module 10: Message Boxes and Input Boxes

  • Creating a Message box
  • Message box return values
  • The Input Box function
  • Excel’s InputBox method
  • Handling input box return values
  • VBA conversion functions
, Microsoft Excel VBA Introduction Training course 2 day
, Microsoft Excel VBA Introduction Training course 2 day