How to declare a global array in a form?

Question

How to declare a global array in a form?
I need the array to be populated in one procedure, and read in another procedure.
With the current code in line 1 ofFillArray_1

array1 = Array( ...

I get an error message:

Expected variable or procedure, not project

Code:

Dim array1() As String                  ' Array

Private Sub Exe_btn_Click()
    PrintArray
End Sub

Public Sub FillArray_1()
    array1 = Array( _
                               "member_1", _
                               "member_2", _
                               "member_3")
End Sub

Public Sub PrintArray()
    FillArray_1                   

    Dim i As Integer

    For i = LBound(array1) To UBound(array1)
                Debug.Print array1(i)
    Next i
End Sub

Usually there is no benefit on using [Integer vars](https://stackoverflow.com/questions/26409117/why-use-integer-instead-of-long?noredirect=1&lq=1) — ComputerVersteher, Sep 03 '19 at 07:30

score 2 · Accepted Answer · answered Sep 03 '19 at 06:33

2

As the error message indicates,Arrayis the name of your project! Rename project or you have to useVBA.Arrayto avoid this conflict:

Public Sub FillArray_1()
    array1 = VBA.Array( _
                               "member_1", _
                               "member_2", _
                               "member_3")
End Sub

answered Sep 03 '19 at 06:33

ComputerVersteher

2,638
1
10
20

Very nice catch! – Andre Sep 03 '19 at 07:33

Gustav · Answer 2 · 2019-09-03T06:03:17.297

1

Not Dim but Public:

Public array1() As String

and it can't be located in the form's module. Move it to a code module.

edited Sep 03 '19 at 06:03

answered Sep 02 '19 at 20:27

Gustav

53,498
7
29
55

Yes. It must be reachable all the time, so move it to a code module. – Gustav Sep 03 '19 at 06:04

score 1 · Answer 3 · answered Sep 02 '19 at 22:14

1

And to fill array1 with the Array() function, you must declare it as Variant.

Dim array1 As Variant

or

Public array1 As Variant

if these functions are in different modules.

answered Sep 02 '19 at 22:14

Andre

26,751
7
36
80

How to declare a global array in a form?

3 Answers3