Return array from UserForm

I'm trying to make a userform for the first time and it's not going well. I have command button on a worksheet that when clicked opens a userform with 3 checkboxes. Depending on which boxes are checked I would like to modify an array for use later on in the command button's sub.

I can't figure out how to build the array in a way that allows me to use it in the sub though. Any assistance would be greatly appreciated. My code is attached.

How do I use the options array afterwards in the CommandButton1_Click private sub?

Please Login or Register  to view this content.

I have a while loop later in the CommandButton1_Click sub. I want to skip iterations of the loop based on the options selected by the user.

For example if the loop runs three times by default I want it to skip the second iteration if the options array has the values [1 0 1].

I can get the userform to write the array to a worksheet and then read those back into a new array in the sub but I would like to find a way to get around the intermediate step.