Loading an xml

[Guest]

Hello - I have a userform that loads an xml file with the initiallization
event then populates a listbox using an xpath query. I need to populate up
to 6 listboxes with filters based on what the user selected from the previous
listbox. So I am loading the xml with click events, and it is a very large
file. Is there a way to load it when the form initializes and keep it loaded
until the form is unloaded?

 

[Tim Williams]

Create a global variable to hold the document and it should be maintained between selections.

 

[Guest]

Okay.. Because it so big, do I need to worry about dumping when the userform
is unloaded?
--
Thanks,
Mike

Create a global variable to hold the document and it should be maintained between selections.

 

[Tim Williams]

If the form is unloaded then it should be dumped automatically.
How big is it?

Tim

Okay.. Because it so big, do I need to worry about dumping when the userform
is unloaded?