Play all

Start

Introduction

Introduction to Forms and Controls

Form Properties, Methods, and Events

Inserting and Modifying UserForm Objects

Using Label Control on Forms

Using Textbox Control on Forms

Using Command Button Control on Forms

Using Combo Box Control on Forms

Using Frame Control on Forms

Using Option Button Control on Forms

Changing Option Button Properties

Formatting Form Controls

Testing and Modifying Tab Order on Forms

Using Code to Populate Combo Boxes and Setting Defaults

Modifying Combo Box Code and Inserting Control Code Files

Reviewing Inserted Code

Testing Modified and Inserted Code

Writing Code to Display Forms

Forms and Controls Recap

Introduction to Pivot Tables in VBA

PivotCache, PivotTable, and PivotFields Objects

Recording Macros to Create PivotCache

Recording Macros to Set Pivot Table Fields

Reviewing Macro Codes

Creating Pivot Tables Programmatically

Creating Code to Set Pivot Table Fields

Finalizing Forms

Reviewing Inserted Code

Finalizing Code

Creating and Modifying Function Procedures

Testing Forms

Adding QAT Icon to Launch Form

Testing Final Forms

Pivot Tables in VBA Recap

Conclusion

Description:

Dive into an advanced Visual Basic for Applications (VBA) tutorial for Excel 2021, designed for business analysts, data scientists, and Excel power users. Master the art of automating repetitive processes and creating custom tools through VBA programming. Learn to navigate the Visual Basic editor, understand the Excel Object Model, and work with various procedures and methods. Explore language elements, including variables, data types, and intrinsic functions. Gain proficiency in creating message boxes, input boxes, and controlling program flow with conditional branching and looping constructs. Delve into form creation, including properties, controls, and events, and discover how to programmatically create Pivot Tables using VBA. By the end of this comprehensive tutorial, acquire the skills to write efficient VBA code, modify recorded macros, and significantly enhance your Excel productivity.

Excel 2021 VBA Advanced Tutorial

Learnit Training

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Spreadsheets #Pivot Tables #VBA Programming #Excel VBA

0:00 / 0:00