Скачать или смотреть Excel VBA Tutorial for Beginners (7/10): Arrays

Get the Excel VBA Guide for Beginners with extended and revised content here: https://excelmacroclass.blogspot.com/...

Welcome to the Excel Macros/VBA tutorial for beginners. In this sixth video we'll understand what arrays are and how to use them in Excel VBA. We will learn how to declare and populate arrays, and also, to work with multidimensional and dynamic arrays (find timeline below).

00:00 What is an array?
01:02 Array declaration
03:32 Lower and upper bound of Array
04:30 Populate array
09:11 Multidimensional arrays
11:41 Dynamic arrays

In the next video we will see how to get the most of message and input boxes in Excel VBA. 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

Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: https://excelmacroclass.blogspot.com/

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:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)