Course Outline

Microsoft Excel Macros & VBA Training Course

This course is designed to be hands-on. You will learn skills that you can apply to your own work. Bring your own projects, files and questions to the training, or use our free support anytime after training.

We specialise in on-site and online customised training, which means we can schedule the course at a date that suits you and tailor the content to address your requirements.

Build your own macros in Excel and write simple Visual Basic code. This course covers:

Record and edit macros
Understand the Object Model
Write Visual Basic routines
Reuse & adapt existing code

Microsoft Excel Macros & VBA Training Course Content

\

Course Objectives

After completing this course you will be able to record, edit and troubleshoot macros, understand the Excel Object Model, write manually simple programming routines in the Visual Basic Editor (VBE) environment as well as reuse and adapt existing code.

Course Duration

Course can be either one day or two and a half-days duration

Who is this Course for

This Excel Macros and VBA course is for existing Excel users with a good understanding of Excel features who need to be able to automate a variety of tasks. Note: Unfortunately, Mac users can no longer programme using VBA.

Course Prerequisites

Familiarity with Excel at the intermediate level is sufficient. No prior knowledge of programming is required to attend this Excel Macros & VBA course.
Macros and Visual Basic

The Power of Excel:

Knowing Your Tools:
The Developer Tab / Macro Toolbar
Macro Security
Adding a Trusted Location
Overview of Recording, Storing, and Running a Macro
Understanding the VB Editor
Recording Macro Basics

Examining Recorded Macro Code:

Using the VB Editor and Help
Optional Parameters
Defined Constants
Properties Can Return Objects
Using Debugging Tools to Figure Out Recorded Code
Referring to Ranges with Excel VBA

Ranges:

The Range Object
Named Ranges
Use the Cells Property to Select a Range
Using the Cells Property in the Range Property
Use the Offset Property to Refer to a Range
Use the Resize Property to Change the Size of a Range
Use the CurrentRegion Property to Select a Data Range
User-Defined Functions in Excel VBA

Functions:

Creating User-Defined Functions
Useful Custom Excel Functions
Looping and Flow Control in Excel VBA

Looping and Flow Control:

Using Variables in the For Statement
Variations on the For…Next Loop
Exiting a Loop Early After a Condition Is Met
Nesting One Loop Inside Another Loop
VBA Loop: For Each
VBA Loop : Do Loops
Flow Control: Using If…Then…Else
Flow Control: Using Select Case
Event Programming in Excel VBA

Event Programming:

Levels of Events
Using Events
Event Parameters
Enabling Events
Workbook Events
Worksheet Events
UserForms in Excel VBA

Userforms in Excel:

Input Boxes
Message Boxes
Programming the Userform
Userform Events
Programming Controls
Using Basic Form Controls

Get a quote

Data Protection:
Business Brains needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy Policy.

3 + 14 =

i

Tailored to your needs

w

Free Support



Results for your business