Microsoft Excel VBA Complete
(2013, 2016, 2019, 2021, 365)
What You'll Learn in Microsoft Excel VBA Complete
Course Length:
Learning Objectives
In this course, you will:
- Record and Run Simple Macros
- Use the VB Editor and Code Window
- Create and Edit VBA Code
- Work with Objects
- Work with Variables
- Create Procedures and Functions
- Work with Forms and Controls
- Understand Debugging
Target Student
This course is designed for students who need to automate repetitive tasks and create simple macros that run in spreadsheets. Knowledge of Excel spreadsheets is recommended.
Course Outline
Section 1: Basic Macro Concepts
How to Record a Macro
Re-recording a Macro
How to Play, Delete, Edit and Rename a Macro
Using Relative Referencing
Running a Macro While Recording Another
Section 2: Macro Security
Section 3: Personal Macro Workbook
Section 4: Dealing with Ranges That Change Size Over Time
Section 5: 8 Different Ways to Run a Macro
Adding to Ribbon, Creating Buttons, etc.
Section 6: Visual Basic for Applications - Basics
The Visual Basic Editor
The VBA Toolbars
Modules
Protecting a Module
Section 7: Writing Code
Objects, Properties and Methods
Using the With Construct
Recording vs. Writing – Pros and Cons
Getting Help with the Object Browser
Declaring and Using Variables
Using Formulas in Macros
Section 8: User Interaction
Input Boxes and Message Boxes
Formatting Input or Message Boxes with the Format Function
Section 9: Adding Special Characters Including Line Breaks
Section 10: IF Statements
Message Boxes That Allow for Input
Section 11: Running Other Procedures
Section 12: Event Trapping
On Error
Auto_Open() and Auto_Close()
Microsoft Excel VBA Complete
Upcoming Classes
All Public classes are held onlinewith a live instructor
I want to talk to someone about private or customized training
Have questions about this course? See below or reach out to our training coordinators.
Group of 4 or more? Consider private training
The Great Canadian Training & Consulting Company Advantage
When you train with us, your training will not just check a box. We make sure it is GREAT!
- Experienced Trainers
- Guaranteed to run classes
- Learning Guarantee
- Anytime after-training support for 30 days
- Bilingual training, Reference Guides & post-training support available
This course comes with
PDF Reference Guide
Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices
Printed Reference Guide
Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference