Course Details close

Course Details

(inc GST)
$ 990
Level:VBA Basic
Duration:2 days
Level 3
321 Pitt St
Sydney NSW 2000
Participants:Max 10
Length:9:00 to 16:30
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Excel VBA Basic Course

   (4.88 out of 5)
357 Excel vba basic student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 2 days Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 990
Sale Price:
(inc GST)

Quick links

Excel VBA Basic Course

Course Overview

This is a two-day training course tailored to give experienced Excel users the skills required to use Excel’s VBA (Visual Basic for Applications). Lead by dedicated instructors with expertise in the Microsoft Office package, you’ll learn how to confidently navigate and utilise the VBA editor to run, edit and debug VBA code. We’ll teach you how to get started with VBA and provide you with a solid foundation on the Excel Object Model along with the associated properties, methods and events which are the building blocks of the VBA programming language.

Raising the Bar training courses are carefully designed so that all students achieve the best possible learning outcomes. You'll be guided by industry experts as you learn earn through clear instructions, insightful demonstrations and hands-on activities. Our class sizes are small so that all students can learn in a supportive environment and we provide all equipment so you just need to show up. Upon completion, you'll leave with brand new skills and knowledge of Excel VBA, with the ability to automate standard features and develop programs. You will have gained the proficiency required to write code and use a range of common programming techniques using Excel VBA.

When you finish the Excel VBA Basics course, you’ll receive a certificate of completion and a course manual you can work through at home to further develop your VBA skills.

Who Should Attend This Course

The Excel VBA Basic Training Course is designed especially for students who already have an advanced knowledge of Excel and utilise these skills on a daily basis. Participants should have working knowledge of how to record and run macros and must be able to confidently nest functions before undertaking this training. This course is perfect for users who want to automate and customise complex calculations and processes in their current work flows.

Typically, students who attend this course already have a high level of confidence with Excel and know how to create professional and productive spreadsheets using Excel’s more complex and technical features and formulas. This course is right for you if you’re an experienced Excel user who wants to learn the basics of using VBA, write code and employ various programming techniques. We’ll familiarise you with the software and teach you how to use VBA securely, run and debug code from the VBA editor, work with variables, loops, perform tests, interact with the user, build your own User Defined Functions, learn how to handle errors and create and implement Excel Userforms.

Our public training courses are available in our Sydney CBD training facility throughout the year. For students in other cities, group training sessions are available by appointment for companies in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.

Course Prerequisites

Our course is designed for experienced Microsoft Excel users. Students should have completed our Excel Advanced course and know how to record and run macros and confidently nest functions before undertaking VBA training. You will also need general computer skills using the Windows operating system.

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

With each course we provide you with a comprehensive course manual for you to practice post course.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

View Course Dates

Face to Face (public course dates)

Online via Webinar (via Microsoft Teams)

Public Course Dates

Course Date Price Add Course Qty Status
11-Jul-24 (Thu)$990.00 0
29-Jul-24 (Mon)$990.00 0

Virtual Classroom Dates (via Microsoft Teams)

Course Date Price Add Course Qty Status
11-Jul-24 (Thu)$990.00 0
29-Jul-24 (Mon)$990.00 0

Course Outline

Getting Started

  • What is VBA?
  • Open the VBA Editor
  • Create a Module
  • Create a New Subroutine
  • Add Commands
  • Run the Subroutine
  • Save the File


  • Open a File Containing Code
  • Create a Digital Signature
  • Digitally Self-Sign a File
  • Add the Publisher to the Trusted List
  • Install Certificates
  • Remove Trusted Publishers

Using the VBA Editor

  • Run Code in the VBA Window
  • Step Through Code
  • Step Over Code
  • Set a Break Point
  • Comment Code
  • IntelliSense and AutoComplete
  • Getting Help
  • The Project Explorer and Properties Window


  • What is a Variable?
  • Naming Variables
  • Store a Value in a Variable
  • Why Should I Declare Variables?
  • Procedure-Level Declarations
  • Module-Level Declarations
  • Global-Level Declarations
  • Static Declarations
  • Option Explicit
  • Declaring Data Types
  • Recognise Errors From Declaring Variables
  • Discover the Current Value of a Variable

Interactions With The User

  • Interacting With the User
  • MsgBox as a Method
  • MsgBox as a Function
  • Message Box using Numerical Constants
  • The InputBox Function
  • Long Messages

Making Decisions

  • A Note On Indenting
  • Line If
  • Block If
  • ElseIf and Else
  • Select Case


  • For/Next Iterations
  • For/Next Stepped Iterations
  • Do/Loop With Initial Test
  • Do/Loop With Final Test

Error Handling

  • Run-time Errors
  • Add a Simple Stop
  • The Err Object
  • Exit Sub
  • Error Handling with Another Sub
  • Resuming

The Personal Macro Workbook

  • Course Prerequisite
  • Record in the Personal Macro Workbook
  • Saving the Personal Macro Workbook
  • Use a Macro from the Personal Macro Workbook
  • Edit a Personal Macro Workbook Macro
  • Locate the Personal Macro Workbook

Excel Objects

  • The Object Hierarchy
  • Locate an Object
  • Properties and Methods
  • The Application Object
  • The Workbooks Object
  • ActiveWorkbook and ThisWorkbook
  • Sheets, Worksheets and Charts
  • The Worksheets Object
  • Simple Range Objects
  • More Complex Range Objects
  • Adding Higher Hierarchical Levels

Common VBA Techniques

  • Copy and Paste
  • Paste Special
  • Offset
  • Insert Calculations in a Cell
  • AutoFill
  • Add/Delete Rows and Columns
  • Convert Data Types

User Functions

  • Functions
  • Single Input Functions
  • Call the Function from Another Procedure
  • Use the Function on the Spreadsheet
  • Multiple Input Functions
  • Use the Multiple Input Function
  • The WorksheetFunction Object

User Forms

  • Insert a UserForm
  • The Project Explorer and Properties Window
  • The Final Product
  • Create TextBoxes and ComboBoxes
  • Align and Resize the Controls
  • Create Labels and use Control Tip Text
  • Create Command Buttons
  • Code the Close Button
  • Populate the Combo Box List
  • Code the Commit Button
  • Create a Macro to open the UserForm
  • Create a Button on the Spreadsheet
  • Automatically Load the Form

Connect to External Databases - Appendix

  • ODBC and VBA
  • Some General Considerations
  • How Does ADO Work?
  • Setting ADO References
  • Connecting to the Database
  • Populate ADO Recordsets
  • Locate a Record using ADO
  • BOF and EOF
  • Filter and Count the Records
  • Add a Record
  • Modify a Record
  • Delete a Record
  • Close the Connection and Recordset
  • Attaching an SQL Database
  • Using VBA with a Local SQL Database

Student Comments

  • Excel VBA Basic training course
    Particularly enjoyed being able to bounce ideas off of Craig. I'm confident based on the real life examples Craig was able to provide that all parts of the course will be relevant.
    - Liam
  • Excel VBA Basic training course
    Very professional, knowledgeable and helpful in all aspects. Blended conventional training/instruction with real-world helpful examples with the utility and benefit of an excel forum.
    - Philip
  • Excel VBA Basic training course
    The ability to ask questions throughout the course was extremely valuable. The course tracks closely to the notes which meant I could listen without having to take notes at the same time and the content covered a broad spectrum of concepts and ways VBA could be applied to real life scenarios. Thank you Craig and Mark.. hopefully I will be back in some capacity
    - Mike
  • Excel VBA Basic Training Course
    Craig was very professional in terms of delivering the course. I was very satisfied in terms of what I have learned. My colleague is certainly looking forward to do this course.
    - Patrick
  • Excel VBA Basic training course
    Craig was awesome!
    - Grant
  • Excel VBA Basic training course
    Excellent course, would highly recommend!
    - Liam
  • Excel VBA Basic Training Course
    Very well taught and excellent introduction into VBA for beginners
    - Charles
  • Excel VBA Basic training course
    The course tracks closely to the notes which meant I could listen without having to take notes at the same time and the content covered a broad spectrum of concepts and ways VBA could be applied to real life scenarios. I felt almost everything covered was necessary in order to create foundation on which to learn properly.
    - Mike
  • Excel VBA Basic training course
    Everything - it was better than I expected. It was enlightening. I have learnt so much in the three days. Thank you Craig
    - Jean-Guy
  • Excel VBA Basic training course
    Can`t wait to do the next level
    - Kylie
  • Excel VBA Basic Training Course
    Very much enjoyed it and am already playing with the acquired knowledge. Excellent!!
    - David
  • Excel VBA Basic Training Course
    Tom was an excellent trainer in every respect. Cerena's help and hospitality were also great!
    - Lawrie
  • Excel VBA Basic Training Course
    I felt that the Tom's presentation was excellent. This is probably the best course of this type of have been on. Also, hats off to Cerena for looking after us well.
    - Peter
  • Excel VBA Basic Training Course
    Excellent course literature and content very helpful
    - Salesh

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

1300 937 782 Contact us