Auldhouse Anywhere

Auldhouse Anywhere

Our range of Auldhouse Anywhere courses enable you to join live classroom training online – saving you time and money on travel.

Find out More
E-Learning

E-Learning

Discover the benefits of taking a course online at your own pace.

Find out More
Webinars

Webinars

Auldhouse deliver a number of vendor specific webinars. Webinars give you an effective training option with the freedom to attend from virtually anywhere.

Find out More

VBA For Excel

Code:
VBAE
Days:
2 Days
Price:
$795 excl GST
Code:
VBAE
Days:
2 Days
Price:
$795 excl GST
CPD Eligible
12 cpd hour(s)
Overview:
This course aims to cover in detail the Visual Basic for Applications programming language. You will be learn how to program in VBA in order to customise your work environment in Excel. You will learn to understand programming terminology such as modules, procedures, variables and constants. You will learn form design, control structures and how to debug and test your VBA application before using it in the work environment.
Download Course Outline
Course Outline (PDF)

Objectives:

The following topics will be covered:
  • Understanding Templates and Macros
  • Looking at the Visual Basic Editor
  • Recording a macro
  • Designing Forms
  • Learning to write code
  • Understanding Procedures
  • Using Variables and constants
  • Understanding Properties, Methods, Events and Objects
  • Understanding the Range Object (in Excel)
  • Control structures
  • Debugging and Error-trapping

Prerequisites:

This course requires an advanced knowledge of Excel. We recommend attending our Microsoft Excel 2013 - Data Analysis and Reporting course prior to attending, or that you have the equivalent experience.

Register now for this course

Please take special note of the course prerequisites as it is important that you meet these requirements before attending the course. If you have any questions about dates or locations please dont hesitate to make an enquiry contact us on 0800 835 835.

Auckland

Christchurch

No classes currently scheduled in your location?Enquire about this course

Interested in a private class? Enquire about a private class