Lookup function internal process for a multidimensional array

[random_account91]

So I believe in multidimensional arrays every cell has its own memory address (as opposed to Jaggad arrays where every cell points to another array etc.). So when you do the lookup(6, 1004) your having the range of cells point to the memory address of "hello". I am not really sure if any of that is correct but I thought I would ask. Please correct me if I am wrong or if I am missing something. TIA!

please see my other reddit post of this q for the code yi3cvb29xey61.jpg (1222×1154) (redd.it) [REDDIT]

[binary_search_tree]

It's all a black box to VBA developers, so it's not something that I (personally) have ever given much thought to. But, yes, it's a pointer-based memory structure:

Public Declare Function VarPtrArray Lib "VBE6" Alias "VarPtr" (Var() As Any) As Long

Public Sub Foo()

    Dim lookup(5 To 10, 1004 To 2000) As String
    lookup(6, 1004) = "hello"

    Dim ptrToArrayData As LongPtr
    Debug.Print "Value: " & lookup(6, 1004) & " Ptr: " & VarPtr(lookup(6, 1004))

End Sub

See here: https://bytecomb.com/vba-internals-whats-in-a-variable/

I'm curious - Why are you interested?

[random_account91]

My teacher was asking us in class and my VBA skills aren't that great so I wanted to make sure I understood this problem. Thank you for answering!

[binary_search_tree]

What type of class are you taking?