one variable and use the variable for another sub in the same user form module ?

[karmapala]

I have a simple Userform with one TextBox (CARI) and one ListBox (ListNama).
The TextBox is used to search an item in a pivot table then added to the ListBox.

Please Login or Register  to view this content.

Except the first line (DrillTo),
I get the rest of the code above from a senior member of this forum long time ago, and it works perfectly.

I would like to have the "MyList" variable is defined on another sub,
so I don't have to define it in CARI_Change sub.

What I mean is something like this :

Please Login or Register  to view this content.

From the code above, I'm expecting that it already knows what are the items in MyList variable,
because it already defined from another sub, for example at the Userform initialize, maybe something like this :

Please Login or Register  to view this content.

I wonder if it's possible to be done.

Any kind of respond would be greatly appreciated.
Thank you in advanced.

[Norie]

Move the declaration of MyList to the top of the userform module.

Then you can set its value in the Initialize event and it will be available throughout the userform module.

[karmapala]

It works.
Thank you very much, Norie.