Virtual Instructor-Led Training

Onsite Training

MS Excel (2016-2013) Programming with VBA

Business Applications

Microsoft Excel

Microsoft

<ul><li>Introducing Visual Basic for Applications</li><li>Displaying the Developer Tab in the Ribbon</li><li>Recording a Macro</li><li>Saving a Macro-Enabled Workbook</li><li>Running a Macro</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Using Visual Basic Help</li><li>Closing the Visual Basic Editor</li><li>Understanding Macro Security</li></ul>

Getting Started

<ul><li>Understanding Modules</li><li>Creating a Standard Module</li><li>Understanding Procedures</li><li>Creating a Sub Procedure</li><li>Calling Procedures</li><li>Using the Immediate Window to Call Procedures</li><li>Creating a Function Procedure</li><li>Naming Procedures</li><li>Working with the Code Editor</li></ul>

Working with Procedures and Functions

<ul><li>Understanding Objects</li><li>Navigating the Excel Object Hierarchy</li><li>Understanding Collections</li><li>Using the Object Browser</li><li>Working with Properties</li><li>Using the With Statement</li><li>Working with Methods</li><li>Creating an Event Procedure</li></ul>

Understanding Objects

<ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Working with Variable Scope</li><li>Using Intrinsic Functions</li><li>Understanding Constants</li><li>Using Intrinsic Constants</li><li>Using Message Boxes</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul>

Using Expressions, Variables, and Intrinsic Functions

<ul><li>Understanding Control-of-Flow Structures</li><li>Working with Boolean Expressions</li><li>Using the If...End If Decision Structures</li><li>Using the Select Case...End Select Structure</li><li>Using the Do...Loop Structure</li><li>Using the For...To...Next Structure</li><li>Using the For Each...Next Structure</li><li>Guidelines for use of Control-of-Flow Structures</li></ul>

Controlling Program Execution

<ul><li>Understanding UserForms</li><li>Using the Toolbox</li><li>Working with UserForm Properties, Events, and Methods</li><li>Understanding Controls</li><li>Setting Control Properties in the Properties Window</li><li>Working with the Label Control</li><li>Working with the Text Box Control</li><li>Working with the Command Button Control</li><li>Working with the Combo Box Control</li><li>Working with the Frame Control</li><li>Working with Option Button Controls</li><li>Working with Control Appearance</li><li>Setting the Tab Order</li><li>Populating a Control</li><li>Adding Code to Controls</li><li>Launching a Form in Code</li></ul>

Working with Forms and Controls

<ul><li>Understanding PivotTables</li><li>Creating a PivotTable Using Worksheet Data</li><li>Working with the PivotTable Objects</li><li>Working with the PivotFields Collection</li><li>Assigning a Macro to the Quick Access Toolbar</li></ul>

Working with the PivotTable Object

<ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints</li><li>Stepping through Code</li><li>Using Break Mode during Run mode</li><li>Determining the Value of Expressions</li></ul>

Debugging Code

<ul><li>Understanding Error Handling</li><li>Understanding VBA's Error Trapping Options</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Writing an Error-Handling Routine</li><li>Working with Inline Error Handling</li></ul>

Handling Errors

Knowledge of PivotTables would be helpful.

courseBanner

Course Banner

courseOverview

Course Overview section

courseDetails

What you will learn

targetAudience

Who should attend

courseOutline

Course Outline

courseFAQ

Coursepromobanner

Course Promobanner Section

courseRelatedTargets

Course Related Targets

courseTicker

Course Ticker

preRequisites

Prerequisites

courseTestimonials

Customer Testimonials

courseLocations

Find More Locations by NetCom Learning For This Training

For Your convenience we are offering This course at more locations. Expand your training options and accelerate your learning journey with NetCom.

Learn to create procedures that run in response to specific events, work with control structures, develop user forms, validate data entry in forms.

VBA: MS Excel (2016/2013) Programming

AI CERTs™

Google Cloud

Cisco

Amazon Web Services

CompTIA

EC-Council

ISC2

ITIL

Autodesk

AI & Data

Cloud

Security

Networking

App Development

Architecture & Design

Business Process

Business & Leadership

e-Learning

Trainings

Managed Learning Services

NetCom365

Learning Passport

EdAssist

Talents for Hire

NetCom Learning Academy

AI Summer Skill Fest 2025

Financial Services

Healthcare

Federal Government

State & Local Government

Technology

Complimentary AI+ Foundation™ Training

Free AI Training Consultation

AI Certs Training Bundles

CompTIA Continuing Education (CE)

CompTIA Exam Prep e-Learning Bundles

Microsoft ECIF Program

Microsoft QuickStart Program

Microsoft Partner Training

Microsoft AI Bootcamp for Educators

Microsoft Applied Skills

AWS Skill Builder

AWS Blended Learning

AWS Learning Needs Analysis (LNA)

AWS e-Learning

Cisco Continuing Education (CE)

Cisco Learning Credits

Cisco U

Free Networking Training Consultation

Google Cloud Leadership AI Training

Solutions

Resources

Company

<p>MS Excel 2016/2013 Programming with VBA teaches how to automate tasks and enhance Excel functionalities using Visual Basic for Applications (VBA).</p>

MS Excel (2016-2013) Programming with VBA

Upcoming Schedules

Course Prerequisites

Recommended

Course Outline