Execute Code based on a set of items contained in an array

[Henk Stander]

If it is possible I would like to have code that executes different macros based on the content of a set of values, or the content of an array.

I populate an array with True and False values, based on a set of selections.
Depending on the selected options the array will contain any of the following sets:
Set1 = {"True", "False", "True", "False", "True", "False"}
Set2 = {"True", "False", "True", "False", "False", "True"}
Set3 = {"True", "False", "False", "True", "True", "False"}
Set4 = {"True", "False", "False", "True", "False", "True"}
Set5 = {"False", "True", "False", "False", "True", "False"}
Set6 = {"False", "True", "False", "False", "False", "True"}

What I would like to do then is to use the Case statement something like this:

Select Case Set
Case 1
program statements
Case 2
program statements
Case 3
program statements
Case 4
program statements
Case 5
program statements
Case 6
program statements
End Select

I hope this is at all possible. Thanks.

[StevenM]

If statements are generally faster than select statements, and in this case it would seem to me doubly so.

So why not something like the following?

Please Login or Register  to view this content.

I didn't test this code, so there might be some mistake in it. But the idea should be correct.

[jindon]

One way

Please Login or Register  to view this content.

[Henk Stander]

Thanks a million, it works like a charm!

[Henk Stander]

Thanks Jindon, I will try this out as well. I don't fully understand what the code does but will try and figure it out.