Login / Register

Excel 2010 VBA Programming

This course is designed to give experienced Excel 2010 users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, v... Show More
Course Prerequisites:
Microsoft Office Excel 2010 Advanced
Request a Quote

Instructor-Led Training (ILT)

Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.


1 Day

Course Content

Unit 1: Visual Basic Editor

Topic A: Visual Basic for Applications
A-1: Discussing VBA
A-2: Preparing Excel for VBA
A-3: Examining the VBE window

Topic B: Object programming
B-1: Examining the Properties window
B-2: Changing an object’s properties
B-3: Using code to change object properties
B-4: Using a method
B-5: Associating VBA code with an event
B-6: Executing VBA code by using a button

Topic C: The Object Browser
C-1: Examining the Object Browser
C-2: Searching in the Object Browser

Unit 2: Programming basics

Topic A: Data basics
A-1: Discussing data types and variables
A-2: Declaring and discussing variables
A-3: Using operators
A-4: Using interaction functions

Topic B: Scope of variables
B-1: Understanding procedure- and module-level scope
B-2: Understanding public scope

Topic C: Scope of procedures
C-1: Creating a Sub procedure
C-2: Calling a Sub procedure
C-3: Creating a Function procedure
C-4: Calling a Function procedure

Unit 3: Control structures

Topic A: Decision structures
A-1: Using the If…Then statement
A-2: Using the If…Then…Else statement
A-3: Using the If…Then…ElseIf statement
A-4: Using the Select Case statement

Topic B: Loop structures
B-1: Using the For…Next loop
B-2: Using the For Each…Next loop
B-3: Using the Do While…Loop statement

Unit 4: Custom dialog boxes

Topic A: User forms
A-1: Adding a user form
A-2: Adding controls to a user form

Topic B: Events
B-1: Attaching an event handler to a control
B-2: Validating data by using event handlers

Unit 5: Debugging and error handling

Topic A: Errors
A-1: Discussing the types of errors

Topic B: Debugging
B-1: Discussing debugging tools
B-2: Setting a breakpoint
B-3: Adding a watch expression
B-4: Using Step Into
B-5: Deleting a watch expression
B-6: Working with the Immediate window
B-7: Working with the Locals window

Topic C: Error handling
C-1: Using the On Error GoTo statement
C-2: Using the On Error Resume Next statement

CTU Training Solutions , Updated: April 24th, 2018

Share with friends

Request a Quote

Your Name

Your Surname

Contact Number

Your Email


Which campus would you like to study at?

Your job title

Will your training be sponsored?


The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

Join the CTU community

Join the CTU Community Portal and gain access to superior resources.

Join for Free

Thank you for printing this page.
0861 100 395
[email protected]


Call me Back

Leave your details and we'll contact you back!

Your Name:

Your Email:

Contact Number:

Choose a campus