Global variants

S

Sueprnaut

Hi,
I need a little help. I have two procedures in my code:

Private Sub Form_Open(Cancel As Integer)
.....
Dim Arr() As Variant
.....
End Sub

Private Sub Form_Close()
.....
End Sub

In the first procedure I create and populate an array. How can I use this
array in the Form_Close procedure? Is there a way to define global variants?
 
S

Stefan Hoffmann

hi,
In the first procedure I create and populate an array. How can I use this
array in the Form_Close procedure? Is there a way to define global variants?
Click to expand...
Declare your array at the beginning of the form module as

Private m_Arr() As Variant


mfG
--> stefan <--
 
K

Klatuu

Do the Dim at the module level, that is right after the Options statements in
the Form module. That way it is visible to all procedures in the module.
 
Top