Losing reference to global dictionary from one userform to another

[RawlinsCross]

Good day,

I have a userform in whose code module I make a dictionary. I've declared the dictionary as an global object in a separate module and by late-scripting set the dictionary inside the userform code module. (The idea being that I can use the dictionary throughout the application).

The only thing is that when I open a second userform and try to reference the dictionary made in the first userform, I lose the reference (i.e. dictionary = nothing).

Does anyone have any experience in this as to why the global object 'disappears'? Is it a late-binding thing? (i.e. would this not happen if I used early-binding?)

 

[bobsan42]

try to refer to it through the parent object e.g.:

Userform1.dictionary

However the parent form must still be loaded. If it is unloaded this call will load it again and you will get a newly initialised dictionary.

Reading again maybe I misunderstood you. Is the dictionary defined in a code module? Can you post the relevant code?

 

[RawlinsCross]

Hey there...

So yeah, the dictionary is formed inside the 1st userform, but is declared as a global variable in a Code Module outside the userform. But as soon as I try to reference the dictionary in a 2nd userform, it's not there! Is there a way to copy a small excel file to a reply? I can send a 'demonstration' excel file.

 

[bobsan42]

Is there a way to copy a small excel file to a reply? I can send a 'demonstration' excel file.

You can upload the file to a cloud storage and post the link.
Or you can simply post the relevant codes.