Excel VBA Tutorial for Beginners (Part 5/10): Variables

preview_player
Показать описание

Welcome to the Excel Macros/VBA tutorial for beginners. In this fifth video we'll talk about variables, and we will learn to declare, define and use variables in VBA. We will understand what's the scope of variables in a VBA project, and will also cover what object variables are used for.

00:00 Intro
00:20 Types of variables
01:15 Variable declaration
03:06 Assign value to a variable
05:12 Scope of variables
09:46 Object variables

In the next video we work with conditional statements and loops. Upcoming videos will cover the contents as per below.

Contents:
1. Introduction
2. Modules and Procedures
3. Excel Object Model
4. The Range Object
5. Variables
6. Conditions and Loops
7. Arrays
8. Messages and Input
9. Userforms
10. Debugging and Error Handling

And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Рекомендации по теме