Home · Course Details

Learn how to create string functions, manipulate charts, work with control and useform events and hot to create Excel applications that interacts with other programs. This Excel Visual Basic for Applications (VBA) Advanced course is suitable for all versions of Excel, and is held in Sydney and Melbourne.

  • 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 string functions, manipulate charts, work with control and useform events and create Excel applications that interact with other programs
  • Prerequisites: Successful completion of MCI’s Excel VBA Introduction course or equivalent knowledge and skills.

  • Work with functions
  • Name ranges
  • Interact with charts using VBA
  • Interact with userform controls
  • Handle data using arrays
  • Create complex userforms
  • Understand the relations of applications and objects
  • Work with errors

String Functions, Excel Functions and Named Ranges

  • Using string functions
  • Using Excel functions in VBA
  • Working with named ranges
  • Chart interaction using VBA

Interacting with charts using VBA

  • Working with object variables
  • Looping of objects
  • Userform controls

Interacting with Userform Controls

  • Using control properties
  • Control and userform events
  • Sub routines in class modules

Handling Data using Arrays

  • Using arrays in VBA
  • Copying using arrays

Creating Complex Userforms

  • Utilising user defined functions
  • Working with dates
  • Looping using arrays
  • Adding additional controls

Interacting with Other Applications

  • Interacting with Outlook
  • Automating emails from Excel
  • Early binding vs late binding

Error Handling

  • Programming for errors

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.