Excel VBA

Course Objectives

Objectives of this course are to enable experienced users of Microsoft Excel to develop high-level macros using Excel’s Visual Basic programming language.

Course Content

Introduction To Macros

  • What is a Macro
  • Recording a Macro
  • Running a recorded Macro
  • Attach Macro to Toolbar, menu or spreadsheet object
  • Edit a Macro

Functions

  • Use VBA to write User defined Functions
  • Test User Defined Functions
  • Access User Defined Functions

Visual Basic Concepts

  • Working with Objects, Properties and Methods
  • Defining variables, constants and data types

VBA Language Structure

  • IF…Then….Else
  • Do….Loop, For…..Next
  • Using built-in functions
  • Defining Sub Procedures
  • Working with arrays

 

VBA Testing

  • Debugging Visual Basic Code
  • Using the step tool
  • Adding watches to variables
  • Handling errors and error values

Create Dialog Boxes

  • Dialog Box design tools
  • Dialog Box objects
  • Using Dialog controls

Advanced VBA Tools

  • Accessing and communicating with other applications
  • Create automatic procedures
  • Add-in Applications

Course Outcomes

On completion of this course, participants will be able to use the Visual Basic programming language to develop high-level macros.

Prior Knowledge

Completion (or equivalent knowledge) of Excel Introduction, Intermediate and Advanced courses is required. Exposure to computer programming is desirable.

 

     

Book Now

 

 

  IT

  

Course Information

  
Inclusions:

  • Interactive, practical and hands on learning
  • Facilitator led training
  • Comprehensive take-home training and reference manual
  • Post-course Help Desk support
  • Certificate of Attendance for participants
  • Morning & afternoon refreshments
  • Delicious cafe lunch
  • Post course follow up

 
Enjoy Perth's best CBD training venue:

Cloisters Level 1, 863 Hay Street
Perth CBD
  

Real People, Real Conversations, Real Results
    
  
  

Roving Training

Need IT Training? Don't have time to go on a course? We are happy to come to you!

One of our expert instructors roams your workplace calling in any users that require coaching in any desktop applications. 

Roving training is perfect if numerous employees need some tips and tricks on various programs. Training is tailored to your individual needs and we are able to train using your own documents.   

    

Customised Solutions

We understand one size does not always fit all. Our team of qualified trainers can create a customised solution tailored to your specific needs.

We are happy to offer closed group sessions or additional dates as you require.

To discuss customisation training, simply call 08 9218 9059 or email admin@ati-mirage.com.au
 

 
 

Logo Bulb
  

Enriching lives.
Empowering organisations.