Public Multidimensional Array 1

[AlexCuse]

Hi All,

I know I have seen this somewhere in this forum of the VBA forum before, but for the life of me I can't find it using the search utilities. Basically what I want to do is have a public multidimensional array available to my form, populate it when the form loads, and have these values available to any subs running on the form. I could've sworn that there was a way to do this by creating the array in a module (but not the form module) and instantiating it somehow, but my memory is a bit fuzzy.

Any attempts to clear it up would be greatly appreciated.

Thanks much,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[ChrisHirst]

add Sub Main() to a module and set it as startup object for the project

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[AlexCuse]

Yeah I am a dope, I realized it about two minutes after I posted... Thanks for the reply though!

Ignorance of certain subjects is a great part of wisdom

 

[HughLerwill]

If you only require the array in one Form you do not appear to require to Dim it Public in a Module.

Just Dim the Array in Declarations on the Form and populate it in the Load event.

HTH Hugh,