Microsoft PowerPoint: Visual Basic for Applications (VBA) Macros | Introduction
PowerPoint Training Series | Level 4
Course Details
Duration: 2 days
Microsoft® PowerPoint® Versions: 2007 | 2010 | 2013 | 2016 | 365
Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request
Course Dates: Contact us to arrange a date | View schedule 
Course Fee: $595 CDN per person + HST or BYOD (bring your own device): $545 CDN person + HST*
Note: public scheduled dates for this course are delivered as live instructor-led classroom training.
Course Overview
This course is designed for the Microsoft PowerPoint user who wants automate tasks using Visual Basic for Applications (VBA) but has little or no programming experience. Students will record VBA macros in PowerPoint using modules, procedures, variables and constants within the Visual Basic Editor (VBE) window.
Prerequisite: Microsoft PowerPoint: Intermediate / Advanced or equivalent knowledge and skills.
Custom training: This course may be delivered at your site or ours as an instructor-led or virtual classroom solution. Contact us at info@avantixlearning.ca for more information including savings for custom group training.
Related training: View all PowerPoint courses
INCLUDED IN THIS COURSE
- Comprehensive course manual or published book
- Keyboard shortcuts quick reference
- Sample and exercise files
- Refreshments (for classes conducted in Avantix Learning classrooms)
- Certificate of completion
- Follow-up email support
Course Topics
Key Concepts
- Using VBA in PowerPoint
- Displaying the Developer tab
- Working in the Visual Basic Editor
- Saving files with macros
PowerPoint Object Model
- What is an object model
- Using the PowerPoint object model
Working with the Visual Basic Editor (VBE)
- Opening and closing the Visual Basic editor
- Displaying windows
- Using the Project Explorer
- Using the Code window
- Moving between Microsoft PowerPoint and the Visual Basic Editor
- Overview of the Properties window
- Purpose of the Immediate window
- Basic code logic
Macro Security in PowerPoint
- Specifying macro security settings using the Ribbon
- Using Trust Centre Settings
Creating Sub procedures
- Sub procedure syntax
- Adding comments
- Conventions when naming macros
- Working with modules and projects
- Using methods and properties
Running Macros
- Running macros in PowerPoint using the keyboard and the Macro dialog
- Running macros using buttons
- Running procedures within other procedures
Using Variables and Constants
- Overview of constants and variables
- Declaring constants and variables
- Specifying scope
If Statements
- Writing If statements
- Using If for single and multiple conditions
Controlling User Interaction
- Overview of the types of dialogs
- Using input boxes and extracting answers
- Creating message boxes
- Specifying status bar messages
- Using dialog box arguments
- Using the Execute, Show and Display methods
Looping
- Using looping to repeat macro steps
Managing Presentation Files
- Using opening and closing methods
- Using the Save and SaveAs methods
- Returning and retrieving information
- Referencing files, folders and drives
- Using methods specific to PowerPoint
Dealing with Errors
- Types of errors
- Simple error handling
- Resuming macros
- Decision structures when dealing with errors
Register Now for a public course at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.
Do you need more information? Contact us!
Updated January 1, 2017.
Copyright 2014-2017 Avantix Learning Inc.
To request this page in an alternate format, contact our staff.
*Prices subject to change.
Custom training
Register now for a public scheduled course or contact us to discuss custom on-site or off-site training options.
Related courses
Microsoft PowerPoint: Intermediate / Advanced
Microsoft PowerPoint: Design for Non-Designers
Microsoft PowerPoint: Designing and Delivering Accessible Presentations | Introduction
You may like
How to Cut a Shape Out of an Image in PowerPoint (Cookie Cutter Trick)
Starting in Microsoft PowerPoint 2013, you can use the Merge Shapes tool to crop an image to a circle. You can use either Intersect or Subtract to cut out a circle (or other shape) from a picture.
5 PowerPoint Keyboard Shortcuts to Start a Slide Show
The outline has been an integral part of Microsoft PowerPoint for many years. It is dynamically linked to slide placeholders and is organized in a hierarchical way.
How to Hide and Unhide Slides in PowerPoint (with Shortcuts)
You can hide slides in PowerPoint presentations so that they do not appear during a slide show unless you want to display them. Typically, you hide slides in Normal View or Slide Sorter View and then run your slide show. During a slide show, you can unhide slides or you can return to Normal View or Slide Sorter View and unhide them.
10 Keyboard Shortcuts in PowerPoint’s Outline View
The outline has been an integral part of Microsoft PowerPoint for many years. It is dynamically linked to slide placeholders and is organized in a hierarchical way.
You may also like
How to Replace Spaces in Excel with Underscores (_), Dashes (-) or Other Values
You can quickly replace blank cells in Excel with zeros, dashes or other number or text values (0, -, N/A, Null or other text). It’s useful to fill blank cells with a number, symbol or value if you want to use the data set as the source for a pivot table or use other data analysis tools.
How to Stop Word from Changing Formatting Automatically
You can stop Word from changing formatting automatically in your documents by turning off AutoFormat As You Type settings in the AutoCorrect dialog box. If text or formatting is changing, there are several options you can turn off.
How to Use Wildcards in Word to Find and Replace
If you want to find and replace text or numbers in Word, you can use wildcards if you are not able to find an exact match. To use advanced find and replace techniques in Word, you will need to expand the Find and Replace dialog box.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca