Course Code: 837

Excel 2010 VBA Macros

Class Dates:
1/22/2019
3/25/2019
Length:
3 Days
Cost:
$1195
Class Time:
Technology:
Office
Delivery:

Overview

  • Course Overview
  • This three-day course takes you through Visual Basic for Applications in Excel, all the way from recording Excel VBA macros through to designing your own user forms. On the way you will learn what variables are, how to write object-oriented programs, how to create loops and much more besides.

  • Audience
  • You must be an Experienced Excel user who wish to automate repetitive tasks or simplify more complex tasks using Excel 2010 Macros and Visual Basic for Applications (VBA) programming language.

Prerequisites

  • You must have good Excel skills and understand key concepts of spreadsheets or equivalent. It is not necessary to have prior programming knowledge. We cover VBA Macro programming concepts from the very basic level.

    Excel 2010 Level 1, 2 & 3.
  • Recommended Courses:

  • Excel 2010 Level 1
  • Excel 2010: Level 2
  • Excel 2010 Level 3

Course Details

  • Recording macros and buttons
  • Absolute and relative recording
  • Where macros can be stored
  • Assigning macros to buttons
  • Selecting cells
  • Selecting cells (absolute)
  • Selecting cells (relative)
  • Selecting to the end of a block
  • Selecting a range by its corners
  • The VB code editor
  • Using Project Explorer
  • Creating modules
  • Basic subroutines and comments
  • Messages and variables
  • Input boxes and message boxes
  • Declaring variables
  • Option Explicit
  • Scope of variables
  • Constants
  • Visual Basic Explained
  • The Excel object model
  • Objects and collections
  • Methods and properties
  • Getting help in VBA
  • Loops and conditions
  • Simple IF conditions
  • Multiple IF and SELECT /CASE
  • Three main types of loop
  • Looping over collections
  • Object variables
  • Looping over collections
  • Event handling
  • Assigning macros to events
  • Cancelling events
  • Functions
  • Declaring functions
  • Passing arguments
  • Debugging and error handling
  • Setting breakpoints
  • Stepping through macros
  • ON ERROR statements
  • Forms
  • Drawing forms
  • Attaching macros to controls
  • Validating form input
  • Referencing other applications
  • Links to Word or Access
  • Working with files and folders