Cart
Login
Find Training
Microsoft Job Roles
Azure
Dynamics
M365
Power-Platform
Microsoft Office
Agile
Applications Infrastructure
Cloud
Data & Analytics
Programming
DevOps
ITIL
Professional Development
Security
Virtualization
CompTIA
PMI
Scrum
Cisco
VMWare
EC-Council
Adobe
Citrix
RedHat
AWS
Tableau
IBM
Microsoft Technical
Topics
Agile
Application & Infrastructure
Cloud
Data & Analytics
Design Multimedia
Programming
DevOps
ITIL/ IT Service Management
Leadership & Professional Development
Modern Workplace
Networking
Project Management
Security
Virtualization
Brands
Microsoft Technical
Microsoft Office
Microsoft Job Role
CompTIA
ITIL
PMI
Scrum
Cisco
VMWare
EC-Council
Adobe
Citrix
RedHat
Agile
AWS
Tableau
DevOps
IBM
Search All Brands
Resources
Learning Methods
Army Credentialing
Learn Now Live
Webinars
Blog
Contact
About Us
A Letter from Our Founder
Facebook Icon
Linkedin Icon
Search Button
Button
Excel 2013/2016 Programming with VBA
Price
$885.00
Duration
3 Days
Delivery Methods
VILT
Private Group
Skip to Class Dates
Request More Information
Printable PDF
/ Omit Schedule
Upcoming Class Dates and Times
Jan 27 - Jan 29, 2021
8:00AM - 4:00PM Central
3 Days
Virtual Instructor Led
GTR
Enroll
Mar 08 - Mar 10, 2021
8:00AM - 4:00PM Central
3 Days
Virtual Instructor Led
GTR
Enroll
Apr 20 - Apr 22, 2021
8:00AM - 4:00PM Central
3 Days
Virtual Instructor Led
GTR
Enroll
Jun 07 - Jun 09, 2021
8:00AM - 4:00PM Central
3 Days
Virtual Instructor Led
GTR
Enroll
Show
More Scheduled Dates
Agenda
1 - GETTING STARTED
Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security
2 - WORKING WITH PROCEDURES AND FUNCTIONS
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Working with the Code Editor
3 - UNDERSTANDING OBJECTS
Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure
4 - USING EXPRESSIONS, VARIABLES, AND INTRINSIC FUNCTIONS
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Declaring and Using Object Variables
5 - CONTROLLING PROGRAM EXECUTION
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...To...Next Structure
Using the For Each...Next Structure
Guidelines for use of Control-of-Flow Structures
6 - WORKING WITH FORMS AND CONTROLS
Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods
Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code
7 - WORKING WITH THE PIVOTTABLE OBJECT
Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with the PivotTable Objects
Working with the PivotFields Collection
Assigning a Macro to the Quick Access Toolbar
8 - DEBUGGING CODE
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions
9 - HANDLING ERRORS
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling