Book Online: Login | Register

1300 658 388

Search form

 

 

This Excel Visual Basic for Applications (VBA) course is suitable for all versions of Excel. VBA is a programming language used in Excel to create and edit automated procedures called macros. Macros can be used in simple ways, such as automating a routine print process,  through to more advanced mini applications within Excel with customised menus and complex user interaction. On this course you will learn how to create and edit recorded macros to perform routine Excel procedures automatically. You will also learn about good programming practices and how to write, edit and debug more complex VBA programs using the Visual Basic Editor.

Course Price (inc GST where applicable): 
$900.00
Locations: 
Sydney, Melbourne
Duration: 
2 days
Versions: 

2002/2003, 2007/10/13

You'll Learn how to: 
  • 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
Course Content: 

An Introduction to Macros

What is Visual Basic for Applications?
Objects properties and methods
Difference between properties and methods
Modules and subroutines
Advantages and disadvantages of macros
Macros in perspective

Creating, Recording and Running Macros

Recording and running macros
Naming a macro
Global vs local macros
Learning Visual Basic for Applications
Relative and absolute recording
Viewing and running macros

The Visual Basic Editor

Beyond the Macro Recorder
Visual Basic Editor orientation
Editing existing macros with the VBE
Showing and arranging VBE toolbars and windows
Running macros from the VBE
Macros that cause errors
Dealing with macros that cause errors
Accessing VBA help

Basic Programming Concepts

Creating subroutines
Inputs and outputs
The InputBox function
Prompting for user input
Communicating with the user
Using variables
Variable data types
Dimensioning variables
Writing subroutines with variables
Declaring variables explicitly

Programming Techniques

Making decisions with VBA
Working with loops
Modular programming
Bringing it all together

User-Defined Functions

Creating a user-defined function
Add a function with Insert Function

Excel Objects

The Object Browser
Working with worksheets
Working with cells and ranges

Assigning Macros

Toolbar buttons
Menu items
Worksheet buttons
Automatic macros

Annex A UserForms

Coding the form
Writing an event procedure
Controlling the tab order
Activating forms

Annex B VBA Workshop

Workshop exercise
Scenario
Planning phase
Coding the solution
The solution
Wrapping up

This Course Suits: 

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 more complex VBA programs using the Visual Basic Editor

Prerequisites: 

Successful completion of TP3 Excel Advanced course or equivalent knowledge and skills.

The Learning Process: 
Preparing to learn

Get the most out of your course by preparing before you attend. TP3 provide pre-course materials that enable you to reflect on and align your learning outcomes with the course content.

After the course

TP3's online Learning Resources contains additional tools and resources to help you consolidate and continue your learning. For more details, click here.

Customising this course: 

TP3 can provide a range of consulting services to better meet your business needs, including closed courses for your organisation, customised course material relevant to your industry and requirements, individual or group coaching and blended learning solutions.

Booking Information: 
Call 1300 658 388 to book this course, or book and pay online below.
Course Dates: 

To sort results, click on column heading.

Guaranteed To Run courses are marked with

Location Course Dates Delivery Method Course Times Price (inc GST) GTR ADD TO CART/WISHLIST
Melbourne

31 Jul 17
1 Aug 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Melbourne

25 Oct 17
26 Oct 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Sydney

25 Jul 17
26 Jul 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Sydney

7 Sep 17
8 Sep 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Sydney

15 Nov 17
16 Nov 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Twitter icon
Facebook icon
Google icon
LinkedIn icon
e-mail icon