6th February 2019

Microsoft Project Visual Basic for Applications

Microsoft Project Visual Basic for Applications Course Overview

Microsoft Project Advanced Training ScotlandThere are many things that you might want Microsoft Project to do which are not built in to the standard tool; create pop up forms, write properties to a text file and with VBA (Visual Basic for Applications), the programming language behind Project, you can automate your own procedures and functions. It is worthwhile learning how to program the other Microsoft Office Tools such as Excel and Word so that you can automate activities between those other tools to extend the capabilities of Project.

This course teaches you how to use VBA to further enhance your use of Microsoft Project.

Course Topics

  • Benefits of VBA
  • Modules and procedures
  • Standard modules and form module
  • Subroutines and functions
  • Procedure calls
  • Creating procedures
  • Variables
  • VBA data types
  • Setting properties
  • Creating command buttons
  • Built in Message & Input Boxes
  • Manipulating objects
  • Properties and methods
  • Manipulating collections
  • Using object variables
  • Understanding events
  • Overview of error handling
  • Errors in design/logic
  • Compile errors
  • Run-time errors
  • Getting feedback on errors
  • Error Handling Techniques
  • Stepping through code
  • Using breakpoints
  • Stepping through procedures
  • Watches – Examining variables and constants

These courses are held on demand in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.