Forum Discussion

Brass Contributor

Jun 12, 2019

Solved

Public array

I'm confused about how to declare a public array. I originally (before I realized that I'll need to reference it elsewhere) had it declared in a Sub in Module4 as follows: Sub MyTest() Dim Hors...

excel

Macros and VBA

EricBrady
Jun 13, 2019
bvelkehere is a good explanation of scope
https://stackoverflow.com/questions/2722146/how-do-i-declare-a-global-variable-in-vba

EricBrady

Copper Contributor

Jun 12, 2019

bvelke try declaring the variable outside of the sub..

public Horse(5) as string

Sub myTest()

Horse(1)="BE"

end Sub

bvelke

Brass Contributor

Jun 12, 2019

EricBrady Thanks but that produces a compile error, "Invalid outside procedure."

EricBrady
Copper Contributor
Jun 13, 2019
bvelkehere is a good explanation of scope
https://stackoverflow.com/questions/2722146/how-do-i-declare-a-global-variable-in-vba