VBA Array in Microsoft Excel 365 for Windows

In this video we discover Arrays in VBA. What are Arrays, what are the different types of Arrays, looping through the elements of an Array, resizing an Array, erasing an Array and so many other things.

Watch the video to understand more about Arrays in detail.

----
00:00 Intro
01:36 Type of Arrays
02:04 Single Dimensional Static Array
04:14 Lbound() and Ubound()
06:57 Looping through elements of an array
08:27 Multi-Dimensional Static Array
12:01 Redim Keyword
13:11 Single Dimensional Dynamic Array
17:02 Redim Preserve
17:47 Multi-Dimensional Dynamic Array
22:17 Erase Keyword
26:46 Two more ways to store values in an array
27:07 Array() function
28:58 Split() function
32:20 Outro
----

Equipment/Software used for recording and editing this video

Disclaimer: The above are affiliate links. At no additional cost to you, we will receive a small commission if you make a purchase using the above links. This helps support the channel. Thank you in advance for your support!

Connect with me on social:

#ExcelVBA #ExcelMacro #VBAExcel #MSExcel #Excel

[philsmith]

I hope that this might be helpful for storing questions in my quiz application? I might get back with some questions after I finish your excellent course. Many thanks.