Passing an array to a userForm

[j_Southern]

I have an array of values created by the code of one userform
I wish to use this array to populate a second userform. When I try to do this the array is always empty for the initialise procedure of the second userform.

Please Login or Register  to view this content.

How can I pass the array to the second form ?
John

[j_Southern]

Perhaps my question would be more interesting if I couched it in a more general way.
Essentially what I would like to learn is:- How do I pass information from one userform to another using VBA code?
Although the sub routines generated for each control Like "Private Sub UserForm_Initialize()" have brackets these don't seem to be useable as a means of passing data.
John

[MickG]

This is an example:-
Command Button in Userform 1 takes array form column "A" of sheet, then fills listbox on Userform 1, then passes it to a sub (FillVars) within Userform2 module as below'

Please Login or Register  to view this content.

This is the code in Userform2 module, Takes passed array "R" and fills listbox on Userform2.

Please Login or Register  to view this content.

[j_Southern]

MickG,
Thanks for your reply. I shall try to adapt it to my case and let you know how I get on.
John

[j_Southern]

MickG,
Ive got it to work. Thanks very much for your help
John

[biliron]

MickG

10 years after...
You saved me.
THANKS....