The skills and knowledge acquired in this course are sufficient to be able to create real-life working VBA applications within Excel 2016. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations.
This course builds on the introductory skills of Level 1. You may also be interested in our Level 2 and Level 3 courses which cover more advanced topics.
Request Course Information
By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.
What you’ll learn
At the completion of this course you should be able to:
Understand the Excel object model and VBA concepts
Work effectively with the main features of the VBA Editor window
Create procedures in VBA
Create and use variables
Create and work with user-defined functions in VBA
Write code to manipulate Excel objects
Use a range of common programming techniques
Create a custom form complete with an assortment of controls
Create code to drive a user form
Create procedures that start automatically
Write a variety of error handling routines
Microsoft Office Applications at DDLS
DDLS is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia’s First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
Quality instructors and content
Expert instructors with real world experience and the latest vendor- approved in-depth course content.
Partner-Preferred Supplier
Chosen and awarded by the world’s leading vendors as preferred training partner.
Ahead of the technology curve
No matter your chosen technologies or platforms, we can help you stay one step ahead.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
Quality instructors and content
Expert instructors with real world experience and the latest vendor- approved in-depth course content.
Partner-Preferred Supplier
Chosen and awarded by the world’s leading vendors as preferred training partner.
Ahead of the technology curve
No matter your chosen technologies or platforms, we can help you stay one step ahead.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
Who is the course for?
This course is designed for users who wish to learn how to use the inbuilt VBA programming language in Excel to enhance their worksheets and automate processes.
We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us via email on ph.training@ddls.com.ph
.
Course subjects
Understanding Excel VBA
Programming in Microsoft Excel
VBA Terminology
Displaying the Developer Tab
The VBA Editor Screen
Opening and Closing the Editor
Understanding Objects
Viewing the Excel Object Model
Using the Immediate Window
Working with Object Collections
Setting Property Values
Working with Worksheets
Using the Object Browser
Programming with the Object Browser
Accessing Help
Code Glossary
Starting with Excel VBA
Using the Project Explorer
Working with the Properties Window
Using the Work Area
Viewing Other Panes
Working with Toolbars
Working with a Code Module
Running Code From the Editor
Setting Breakpoints in Code
Stepping Through Code
Procedures
Understanding Procedures
Where to Write Procedures
Creating a New Sub Routine
Using IntelliSense
Using the Edit Toolbar
Commenting Statements
Indenting Code
Bookmarking in Procedures
Code Glossary
Using Variables
Understanding Variables
Creating and Using Variables
Explicit Declarations
The Scope of Variables
Procedure Level Scoping
Module Level Scoping
Understanding Passing Variables
Passing Variables by Reference
Passing Variables by Value
Understanding Data Types for Variables
Declaring Data Types
Using Arrays
Code Glossary
Functions in VBA
Understanding Functions
Creating User-Defined Functions
Using a User-Defined Function in a Worksheet
Setting Function Data Types
Using Multiple Arguments
Modifying a User-Defined Function
Creating a Function Library
Referencing a Function Library
Importing a VBA Module
Using a Function in VBA Code
Code Glossary
Using Excel Objects
The Application Object
The Workbook Objects
Program Testing with the Editor
Using Workbook Objects
The Worksheets Object
Using the Worksheets Object
The Range Object
Using Range Objects
Using Objects in a Procedure
Code Glossary
Programming Techniques
The MsgBox Function
Using MsgBox
InputBox Techniques
Using the InputBox Function
Using the InputBox Method
The IF Statement
Using IF for Single Conditions
Using IF for Multiple Conditions
The Select Case Statement
Using the Select Case Statement
For Loops
Looping with Specified Iterations
The Do Loop Statement
Looping with Unknown Iterations
Code Glossary
Creating Custom Forms
Understanding VBA Forms
Creating a Custom Form
Adding Text Boxes to a Form
Changing Text Box Control Properties
Adding Label Controls to a Form
Adding a Combo Box Control
Adding Option Buttons
Adding Command Buttons
Running a Custom Form
Programming UserForms
Handling Form Events
Initialising a Form
Closing a Form
Transferring Data From a Form
Running Form Procedures
Creating Error Checking Procedures
Running a Form From a Procedure
Running a Form From the Toolbar
Code Glossary
Automatic Startup
Programming Automatic Procedures
Running Automatic Procedures
Automatically Starting a Workbook
Error Handling
Understanding Error Types
The on Error Statement
Simple Error Trapping
Using the Resume Statement
Using Decision Structures in Error Handlers
Working with Err Object
Error Handling in Forms
Coding Error Handling in Forms
Defining Custom Errors
Code Glossary
Prerequisites
This course assumes a good knowledge of working with Excel. The learner should be able to create and edit workbooks, enter formulas, copy, paste, and format data. The learner must also have a general understanding of personal computers and the Windows operating system environment and be able to use File Explorer to locate and copy files.
Terms & Conditions
The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.
Request Course Information
By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.
