Home · Course Details

VBA is a programming language used to create and edit automated procedures in Excel called macros. Macros can be used in simple ways, such as automating a routine print process, and for more advanced application automation and design within Excel. On this course you will learn how to create and edit recorded macros, use Visual Basic programming to code and edit more complex procedures, design appropriate user interaction for your macros to make them easy to use and build error checks into your macros to handle errors and maintain integrity. You will also learn about good programming practices and how to write, edit and debug more complex VBA programs using the Visual Basic Editor.

  • Duration: 2 days
  • Versions: This course is suitable for users of Office 2010, 2013, 2016 and 2019
  • Target Audience: This course will suit you if you are an experienced Excel user who needs to create and edit recorded macros to perform routine Excel procedures automatically, learn about good programming practices and how to write, edit and debug.
  • Prerequisites: Successful completion of MCI’s Excel Advanced course or equivalent knowledge and skills.

  • Understand the fundamentals of VBA
  • Record, test and run macros
  • Access help
  • Make macros interactive
  • Assign macros to buttons
  • Create user-defined functions
  • Declare and use variables
  • Create user forms

Understanding Excel VBA

  • Navigating the VBA Editor
  • Understanding the Excel Object Model
  • Using the Object Browser
  • Getting help with VBA

Starting with Excel VBA

  • Working with the Project Explorer
  • Running code from the Editor
  • Creating break points
  • Stepping through code

Writing Procedures

  • Writing a new Sub Routine
  • Inserting comments in  code

Using Variables

  • Understanding variables
  • Using scoping
  • Declaring data types

Functions in VBA

  • Creating user-defined functions
  • Using functions in VBA

Using Excel Objects

  • Understanding Excel Objects
  • Using Excel objects in code

Programming Techniques

  • Using Msgbox
  • Using Inputbox
  • Using IF for conditional tests
  • Using Select Case

Creating Custom Forms

  • Designing and creating custom forms

Programming User Forms

  • Designing user input
  • Adding form controls
  • Handling events
  • Running and testing custom forms

Automatic Startup

  • Programming automatic procedures
  • Automatically starting a workbook using VBA

Error Handling

  • Simple error traps
  • Using OnError
  • Coding error handling in forms

Name Date Time Location Cost

Not quite the content you’re looking for?

Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.