This program will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.

Overview

This program will introduce and extend VBA programming within Microsoft Excel to enable participants to create and manage complicated macros.

Program Content

  • Understand the Visual Basic Editor (VBE)
  • Object oriented programming concepts
  • Work with cells
  • Work with basic variables and arrays
  • Interact with the user
  • Decision making
    • IF, CASE and LOOP statements
  • Error handling
  • Basic event handling.

Learning Outcomes

Participants should be able to:

  • Create and edit macros by writing VBA code in the VBE
  • Understand concepts of object oriented programming
  • Build user-defined functions in Excel
  • Use events to trigger VBA procedures.
Program Number
936
Skill Level
Advanced
Duration

2 Days

Time
Dates
    Location

    AIM WA Floreat

    * Minimum numbers are required for program to proceed

    Make a Booking
    NOT YET AN
    AIM WA MEMBER?
    DISCOVER THE BENEFITS  

    Similar Programs