UserForm Procedures with Arguments?

[CrazyFileMaker]

Hello,

My question is about passing arguments to UserForm procedures.

I've created a Main procedure. Main calls a sub procedure and returns an array. Obviously Main can now use the array.

But then Main calls a sub procedure to open my userform.

All of my userform sub procedures need to use the array I created in Main. Do I have to pass the array into all of my userform procedures? Into the UserForm_Show procedure? And then again into UserForm_Initialize? And then again into ComboBox_Change?

How would I do this?

I don't understand how to give my UserForm procedures the array from my Main procedure.

Thanks for any and all help!

[Leith Ross]

Hello CrazyFileMaker,

Declare your array as Public in the General procedure section of the Main Module. This will retain the values as long as Excel is running and be available to all other modules in your VBA project, including UserForms.

[CrazyFileMaker]

Thanks Leith!

That helps me a lot!

Cheers!