Course
Skills
VBA Fundamentals
Introduction to VBA programming
What you'll learn
This course will help developers of any level get the most out of the Visual Basic for Applications (VBA) environment. Starting with the development environment and working through various aspects of the language, you will learn the tools and techniques needed to build custom solutions for Microsoft Office.
Table of contents
Introduction to VBA Fundamentals
5mins
The VBA Environment
52mins
- Introduction 2m
- Configuring for Development 4m
- The Developer Tab 6m
- Macro Security 2m
- The Visual Basic Editor: The Macro Recorder 6m
- The Visual Basic Editor: The Standard Toolbar 3m
- The Visual Basic Editor: The Project Explorer 4m
- The Visual Basic Editor: The Properties Window 1m
- The Visual Basic Editor: The Editor Window 3m
- The Visual Basic Editor: The Edit Toolbar 2m
- The Visual Basic Editor: The UserForm Toolbar 5m
- The Object Browser 2m
- The Debugger: The Debug Toolbar 5m
- The Debugger: The Immediate Window 1m
- The Debugger: The Locals Window 1m
- The Debugger: The Watch Window 1m
- The Debugger: The Call Stack 0m
- The Debugger: Compiling Code 1m
- Developer Add-Ins 6m
- Summary 1m
The VBA Language, Part 1
42mins
The VBA Language, Part 2
47mins
The Object Model
15mins
The Event Model
12mins
Debugging and Error Handling
13mins
Putting it Together
28mins
- Overview 1m
- The Quick Access Toolbar 2m
- The Office Fluent User Interface 5m
- Demo 1 - Step by Step 2m
- Demo 2 - Boxes 1m
- Demo 3 - Dynamic Ribbons 2m
- Which Customization? 1m
- RibbonX in Microsoft Access 2m
- Project Types 5m
- Automatically Starting an Application 1m
- Adding Polish 5m
- Summary 0m
- Course Summary 1m