Using array from another sub

Question

I have a sub (initialisation) which contains several arrays. I am then creating another sub (testSub) which have to access one of the arrays in initialisation. I am unsure how to do this and would appreciate any help you can offer.

Initialisation sub:

Sub initialisation()

   init_array = Array("apple", "orange", "car")

   init_array_2 = Array("coconut", "keys", "blue")

End Sub

testSub:

Sub testSub()

For Each element in init_array 'Does not work currently
   [do stuff]
Next

End Sub

You need to pass the array to the second sub either byRef or byValue Sub testSub(init_array as Variant). — FAB
– FAB, Commented Jun 13, 2019 at 11:11
You coul declare your array as Public, so you can access from anywhere in your project. Check stackoverflow.com/a/51865287/9199828 and read the section Dim vs Private vs Public — Foxfire And Burns And Burns
– Foxfire And Burns And Burns, Commented Jun 13, 2019 at 11:16

Damian · Accepted Answer · 2019-06-13 11:12:01Z

4

You need to pass it as parameter like this:

Option Explicit
Sub initialisation()

    Dim init_array As Variant, init_array_2 As Variant

    init_array = Array("apple", "orange", "car")
    init_array_2 = Array("coconut", "keys", "blue")
    testSub init_array

End Sub
Sub testSub(init_array As Variant)

    Dim element As Variant

    For Each element In init_array 'Does not work currently
       [do stuff]
    Next

End Sub

You should also use Option Explicit which will force you to declare all your variables.

answered Jun 13, 2019 at 11:12

Damian

5,1741 gold badge12 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michał Turczyn · Accepted Answer · 2019-06-13 11:16:17Z

2

You can also define your arrays outside subs:

Option Explicit

Dim init_array As Variant, init_array_2 As Variant

Sub initialisation()
    init_array = Array("apple", "orange", "car")
    init_array_2 = Array("coconut", "keys", "blue")
End Sub
Sub testSub()
Dim element As Variant
For Each element In init_array 'Does not work currently
   [do stuff]
Next

End Sub

answered Jun 13, 2019 at 11:16

Michał Turczyn

41.2k18 gold badges58 silver badges87 bronze badges

2 Comments

ChartProblems Over a year ago

I have tried this solution along with declaring the sub as public but I still can't make this work. I get the same error that init_array is empty.

Michał Turczyn Over a year ago

Because you need to execute initialisation before testSub and do it in one Sub, otherwise you'll get an error

Collectives™ on Stack Overflow

Using array from another sub

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related