global 2 column array

Hi everyone,

First post , I am using Excel 2007.

I'm having a problem with something that I think should be easy to do. I'm trying to create a global 2 column array, from what I could understand I'm supposed to declare an array outside of any procedure and then initialize that array during a load event, userform_initialize. However, I am unable to produce code that works as such can someone please show me a simple example of creating and using a global 2 column array in VB. Any help would be greatly appreciated.

Currently, I have the following array created during a click event but I can't use it outside of click event without having to repeat the code.

HTML Code: 

Thanks,
Oscar

Hi Norie,

I have declared the array inside a sub, inside of the user form behind code. I know i'm not supposed to declare it there if I want it to be global but I can't produce code that works any other way. Below is where I declare the array.

HTML Code: