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.