How to pass a 2D+ array from a procedure to a userform

[robby.brooks]

Hello,

This is my first posting here, so please be kind if my posting etiquette is not quite up to snuff.

I am unable to access a public variable (of type Variant) within the "Private Sub UserForm_Initialize()" procedure. I get a Run-time error '13' message. Troubleshooting this, I see that the array variable is now empty.

The goal of this in my actual vba (which is much more complicated) is to generate an array during the normal course of a Sub in Module1, and then display a userform which will populate the 2 dimensions of the array in a listbox with the contents of the array (2 columns), which displays the data to the user.

Here is a very simplified version of what I'm trying to do...

Module 1
-----------

Please Login or Register  to view this content.

UserForm>Initialize code
-----------------------------

Please Login or Register  to view this content.

Any help is much appreciated, as I've spent quite a bit of time googling without finding a clearcut answer.

Thanks!!!

[robby.brooks]

I guess this is one of those situations where Excel decides to hiccup and a restart fixes everything.

This works as I described once Excel was restarted.