Play all

Start

Introduction

Getting Started

VBA Overview

Adding the Developer Tab to the Excel Ribbon

Record Macro Dialog Box

Recording Macros

Testing Macros

Visual Basic Editor Overview and Changing Font Settings

Customizing VBE Toolbar

Editing VBA Code Generated by Recording a Macro

Using the Properties Window to Rename Objects

Saving Macro-Enabled Workbooks

Testing Macro Changes in Another Excel File

Undoing Macro Steps and Modifying Trust Center Settings

Getting Started Recap

Excel Object Model Hierarchy Overview and Collections

Referencing Objects

Introduction to Procedures and Functions

Understanding Module and Procedure Types

Naming Rules and Conventions for Procedures

Starting Macro Recordings from the Status Bar

Creating a Macro that Copies Data from Another File into the Current File

Reviewing Methods and Examples

Reviewing Newly Generated Code

Creating a Sub-Procedure from Scratch Using the Insert Menu

Modifying Two Existing Sub-Procedures

Executing Procedures and Creating a Calling Procedure from Scratch

Understanding the Scope of Procedures

Testing Calling Procedures

Creating Event Procedures

Testing Calling Procedures

Creating Function Procedures

Testing Function Procedures in the Immediate Window

Testing Function Procedures in Excel - User Defined Function

Accessing Context Specific Help from VBE

Procedures and Functions Recap

Conclusion

Description:

Dive into the world of Visual Basic for Applications (VBA) in Excel 2019 with this comprehensive beginner tutorial. Learn to automate repetitive processes, build custom tools, and unlock new possibilities in Excel. Start by understanding VBA basics, adding the Developer tab, and recording macros. Progress to editing VBA code, exploring the Visual Basic Editor, and customizing settings. Master the Excel Object Model hierarchy, create various types of procedures and functions, and understand their scope. Discover how to reference objects, use the Properties window, and save macro-enabled workbooks. Practice creating and modifying sub-procedures, calling procedures, and developing user-defined functions. By the end of this 2-hour 11-minute tutorial, gain the foundational skills to write your own VBA code and enhance your Excel capabilities for data analysis and business tasks.

Excel 2019 VBA Beginner Tutorial

Learnit Training

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Manipulation #Data Analysis #Spreadsheets #Macros #Excel VBA

0:00 / 0:00