All geek questions in one place

Naming Arrays in Excel VBA

I work with three-dimensional arrays, and that would be neat if I could name the dimensions of the array. The question marks in the example below give me an idea that this is possible.

This, and if so, how does it work? I can't seem to find anything.

Example

+4
source share
1 answer

Three question marks show you that this array has three dimensions. If there was only one question mark, this would mean that the variable was declared as one-dimensional. As far as I know, this is built into VB and cannot be changed.

, , . , , , , .

- SchoolID, - ClassID, - StudentID, ,

Debug.Print Schools(10).Classes(3).Students(7).Name

,

Debug.Print arrLeeftijdenG5(10,3,7)

, , . , . , .

+2

Source: https://habr.com/ru/post/1623454/

More articles:


All Articles